Re: Capture SQL stmt from ORA-54

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Mon, 4 Jul 2005 08:18:07 +0800
Message-ID: <5e304862050703171852524eac@mail.gmail.com>

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_at_acxiom.com> 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_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 03 2005 - 19:20:03 CDT