Dbms_system

[san]

Hi All ,

I am trying to run the dbms_system package to trace a session in a pl/sql block , It gives me the following error....

exec dbms_system.set_sql_trace_in_session(my_userid,my_serial,TRUE);
*
ERROR at line 27:
ORA-06550: line 27, column 7:
PLS-00103: Encountered the symbol "DBMS_SYSTEM" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "DBMS_SYSTEM" to continue.

Can I use the package in this pl/sql block ?

Without this statement it compiles well.

When I run this from sqlplus , it runs fine.



Thanks in advance ...

San