Capture SQL stmt from ORA-54 2005-07-03 - By Connor McDonald
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@(protected)> wrote:
>
>
>
> Is there any way to capture the SQL statement that generates an ORA-54 (See ORA-54.ora-code.com)?
> I've got a trigger set on my database to capture all possible ORA- errors,
> but for ORA-54 (See ORA-54.ora-code.com) 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@(protected)
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
|
|
