? dbms_system.start_trace_in_session('SID','SERIAL#', True, True) ?
yakub21Oct 25 2007 — edited Oct 25 2007Thanks in advance.
On Oracle9, Oracle10 what is the correct syntax for start_trace_in_session ?
This seems to work but I want to make certain that I capture the bind variable values.
exec sys.dbms_system.set_ev(SID, SERIAL#,'10046',12,'');
SQL> exec dbms_system.set_sql_trace_in_session(SID,Serial#,TRUE);
My objective is to capture a batch job execution process with and include the bind variable values up to the point and time that the batch PL/SQL job fails. Any Ideas? Thanks