View Single Post

   
  #4 (permalink)  
Old 02-23-2008, 07:37 AM
Mark D Powell
 
Posts: n/a
Default 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 --
Reply With Quote