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-l