Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10053 trace for sql fired from pl/sql (stored code)
Boris,
as the other posters already pointed out, you can request the 10053 trace the same way you would a 10046 (aka sql_trace, or Cary trace):
From within the stored procedure using execute immediate 'alter session
...'
From outside the SP, from a different session, you can use
dbms_system.set_ev(sid, serial#, event#, level, '');
Both methods work independent of the Oracle release (at least the current mainstay releases 7.3 through 10.2).
Boris Dali wrote:
> Any trick that makes it possible to obtain this
> somehow?
>
> Thanks,
> Boris Dali.
>
-- Regards Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 22 2005 - 21:14:20 CST