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....
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 ...
Last edited by san; 10-12-2004 at 05:30 PM.
exec is a sql*plus command. call the package directly.
Click Here to Expand Forum to Full Width