Re: Debugging a failing trigger

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 3 Mar 2015 12:11:37 +0100 (CET)
Message-ID: <298950985.147489.1425381098033.JavaMail.open-xchange_at_app02.ox.hosteurope.de>

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

Received on Tue Mar 03 2015 - 12:11:37 CET