Re: Debugging a failing trigger

From: August Spier <gus.spier_at_gmail.com>
Date: Tue, 3 Mar 2015 07:03:29 -0500
Message-Id: <EFC79893-9F13-44A8-8AFB-C4182DF9E696_at_gmail.com>

Is there documentation or a good article that actually explains "set event" and it's syntax ? I've been looking in the SQL reference , but usually only in crisis mode, when I'm too flustered to actually read anything?

Thanks,
Gus

Gus Spier
Gus.Spier_at_gmail.com

540 454 3074

> On Mar 3, 2015, at 06:11, Stefan Koehler <contact_at_soocs.de> wrote:
>
> Hi Peter,
> i can not test it quickly as i have no failing trigger, but the correct event syntax in this case would be something like this.
>
> alter session set events '4088 trace name errorstack level 3';
> or
> alter system set event='4088 trace name errorstack level 3' scope=spfile;
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK
>

>> "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> hat am 2. März 2015 um 22:50 geschrieben:
>> 
>> 
>> This is Oracle 11.2.0.4 on Red Hat Linux 6.6.
>> 
>> We have a trigger which is failing and the application, Costpoint 7.1, is returning ora-4088 and ora-6512 plus line numbers in the trigger code. How
>> can I force Oracle to dump a trace file to show me the rest of the error stack?
>> 
>> I tried "alter system set event=ora-4088 scope = spfile" followed by a restart, but the error does not produce a trace.
>> 
>> What am I missing?
>> 
>> Thanks,
>> Peter Schauss
>> --
>> http://www.freelists.org/webpage/oracle-l

> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 03 2015 - 13:03:29 CET