dbms_session.set_sql_trace

hi,

[Quoted] [Quoted] I have a stored procedure in which I want to invoke tracing. To this end I inserted the line:

dbms_session.set_sql_trace(true);

prior to the first executable line of code.

when I run my test in SQL*Plus the following occurs:

SQL> _at_test

begin ns_val_sale.menu(-13, '000000003H'); end;

*
ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 32
ORA-06512: at "SHELL_DBA.NS_VAL_SALE", line 2229
ORA-06512: at line 1

however, If I simply execute the procedure form the command line it works fine:
SQL> execute dbms_session.set_sql_trace(true);

PL/SQL procedure successfully completed.

I would greatly appreciate it if someone could tell me what I am missing.
Why can I execute from the command line and not from the script. DBMS_OUTPUT works fine by way of reference.

Kindest Regards,

Ian Wood
NovaLIS Technologies
iwood_at_novalistech.com Received on Wed Mar 18 1998 - 00:00:00 CET