Re: after serverrror on database trigger "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 -- |