X-list: oracle-l Return-Path: Subject: Re: 10053 trace for sql fired from pl/sql (stored code) From: Wolfgang Breitling Message-id: 43AB091C.2050606@centrexcc.com Date: 2005-12-22 21:14:20 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