-
Dbms_system
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
Last edited by san; 10-12-2004 at 04:30 PM.
san
-
exec is a sql*plus command. call the package directly.
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|