RE: RE: Advance Oracle Trigger Writing Advice

2002-06-18 Thread Aponte, Tony
Title: RE: RE: Advance Oracle Trigger Writing Advice Hi Hannah, I think you could use a simpler feature to brute-force a trace of your trigger's execution path.  The SYS.DBMS_SYSTEM.KSDWRT procedure provides output facilities for the alert.log and session trace

RE: RE: Advance Oracle Trigger Writing Advice

2002-06-18 Thread johanna . doran
ECTED]@SUNGARD On Behalf Of "Stephane >Faroult"<[EMAIL PROTECTED]> > Sent: Tuesday, June 18, 2002 6:48 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Advance Oracle Trigger Writing Advice > > Hanna, > >I still have a fairly confus

RE: RE: Advance Oracle Trigger Writing Advice

2002-06-18 Thread Stephane Faroult
Hanna, I still have a fairly confused view of what your problem is and how you plan to solve it. Jean is right about the solution - autonomous transactions are the easier way (dbms_pipe is the other one) to ensure that you will not lose any track of your debugging information even if the tr