Re: after serverrror on database trigger

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 5 Feb 2004 12:20:11 -0800
Message-ID: <2687bb95.0402051220.188e6fe7@posting.google.com>

"Jon" <aaa_at_bbb.ccc> wrote in message news:<bvto8b$rr4$1_at_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 -- Received on Thu Feb 05 2004 - 14:20:11 CST