Re: Capture SQL stmt from ORA-54
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 4 Jul 2005 08:18:07 +0800
Check the application developers guide for "system events" in
triggers. It lists some pre-defined "attribute function" calls that
return all sorts of useful attributes.
hth
connor
On 7/3/05, Herring Dave - dherri <Dave.Herring@xxxxxxxxxx> wrote:
>
>
>
> Is there any way to capture the SQL statement that generates an ORA-54?
> I've got a trigger set on my database to capture all possible ORA- errors,
> but for ORA-54 errors, only the USERNAME, OSUSER, and PROGRAM get captured.
> I'm running on Oracle 9.2.0.4 on Tru64 5.1. Any help would be appreciated.
>
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
