Try referring with the Object owner sys like
sys.dbms_system.set_sql_trace_in_session( );
within a PL/Sql Loop..
-Thiru
Franz Mueller <franz.mueller_at_orbis.de> wrote in message
news:377ced1d.25100082_at_news.salink.net...
> Hi,
>
> I would like to trace the queries from a given app. How can I make a
> trace file that I could later analyze with "tkprof80"?
> If I try the "dbms_system.set_sql_trace_in_session(sid,serial,true)" I
> get a "identifier must be declared" error message. What is wrong?
>
> Thank you
> Franz
Received on Fri Jul 02 1999 - 14:54:12 CDT
