Re: Trace SQL commands in PL/SQL

From: Thomas Sommerfeld <TSommerfeld_at_gmx.de>
Date: Sun, 17 Sep 2000 22:08:07 +0200
Message-ID: <MPG.142f43142b2f3c47989681@news.baden-online.de>

Hi Michael,

thanks for your help, but I use Oracle 8.0.6 and don't have the DBMS_PROFILER package. Is there a similiar function in Oracle8?

Thank you
Thomas

In Artikel <8q36bs$6ho$1_at_nnrp1.deja.com> sagt michael_bialik_at_my-deja.com ...
> Hi.
>
> You can use DBMS_SESSION.SET_SQL_TRACE ( TRUE ); from your PL/SQL
> code to start trace ( FALSE - to stop ).
> With Oracle 8i you may trace PL/SQL code as well with DBMS_PROFILER
> package.
>
Received on Sun Sep 17 2000 - 15:08:07 CDT