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

Thread: dbms_system package

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    I just want t o generate a trace file for some session .

    But i am getting following error when i execute below sql.

    SQL> execute dbms_system.set_sql_trace_in_session(15,4300,true);
    BEGIN dbms_system.set_sql_trace_in_session(15,4300,true); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    ************************

    when i see this package using TOAD , i could see
    package dbms_system wrapped message. What could be the reason for this ? what is the solution ?

    thanks in advace







  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    try

    execute sys.dbms_system.set_sql_trace_in_session(15,4300,true);

    Regards
    Gert

  3. #3
    Join Date
    Oct 2000
    Posts
    57
    thanks

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