system event trigger: after server error: i like to know if it possible to
retrieve TEXT error and not only its code (server_error(1)) in a after
server_error trigger. Thanks

Jon wrote:

> system event trigger: after server error: i like to know if it possible to
> retrieve TEXT error and not only its code (server_error(1)) in a after
> server_error trigger. Thanks

Look at the demo at the bottom of the page at:
http://www.psoug.org/reference/system_trigger.html

Specifically: "IF (IS_SERVERERROR(1017)) THEN"

HTH

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

"Jon" <aaa@bbb.ccc> a écrit dans le message de news:bvto8b$rr4$1@unbe.sarenet.es...
> system event trigger: after server error: i like to know if it possible to
> retrieve TEXT error and not only its code (server_error(1)) in a after
> server_error trigger. Thanks
>
>

With the error number you can get the message with sqlerrm.
Remember sqlerrm takes negative error number.

Regards
Michel Cadot

"Jon" <aaa@bbb.ccc> wrote in message news:<bvto8b$rr4$1@unbe.sarenet.es>...
> system event trigger: after server error: i like to know if it possible to
> retrieve TEXT error and not only its code (server_error(1)) in a after
> server_error trigger. Thanks

I believe that depending on what exactly you want you could
potentially use the dbms_utility.FORMAT_ERROR_STACK function

or if you have the SQLCODE value then use the sqlerrm(v_SQLCODE) call
to get the short error description

HTH -- Mark D Powell --