Dbms_system
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dbms_system

  1. #1
    Join Date
    Jan 2002
    Posts
    16

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    exec is a sql*plus command. call the package directly.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2002
    Posts
    16
    Thank you!
    san

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width