Re: 10053 trace for sql fired from pl/sql (stored code)

  • From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
  • To: cichomitiko@xxxxxxxxx
  • Date: Thu, 22 Dec 2005 14:51:29 -0400

Hi,

Guess should be

execute immediate 'alter session set events ''10053 trace name context
forever, level 1''';
---------------your code

execute immediate 'alter session set events ''10053 trace name context
off''';

Thanks and Regards

Sriram Kumar


On 12/22/05, Radoulov, Dimitre <cichomitiko@xxxxxxxxx> wrote:
>
> > Any trick that makes it possible to obtain this
> > somehow?
>
> Put this before/after the sql statement:
>
>
> execute immediate 'set events ''10053 trace name context forever, level
> 1''';
>
> ...................
>
> execute immediate 'set events ''10053 trace name context off''';
>
>
>
>
> Regards,
> Dimitre Radoulov
>
>
>
>

Other related posts: