FAQ
All Im trying to run the following statement

EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

And get the following error

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

Looking under SYS schema I have package and package body for DBMS_SYSTEM
and the body includes
SET_SQL_TRACE_IN_SESSION

I had to turn on tracing on the database level...
What could be the matter with this??

Many Thanks in advance
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: bmetelsky_at_cps92.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Naveen Nahata at Oct 3, 2002 at 7:18 pm
    From which schema are you trying to run this procedure?
    I can run it from Sys schema. If you are not running it from Sys schema then
    use

    EXEC sys.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

    This should work if you have the privileges

    Regards
    Naveen

    -----Original Message-----
    Sent: Thursday, October 03, 2002 11:49 PM
    To: Multiple recipients of list ORACLE-L
    declared

    All Im trying to run the following statement

    EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

    And get the following error

    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

    Looking under SYS schema I have package and package body for DBMS_SYSTEM
    and the body includes
    SET_SQL_TRACE_IN_SESSION

    I had to turn on tracing on the database level...
    What could be the matter with this??

    Many Thanks in advance
    bob

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bob Metelsky
    INET: bmetelsky_at_cps92.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Naveen Nahata
    INET: naveen_nahata_at_mindtree.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Yechiel Adar at Oct 6, 2002 at 9:18 am
    I think that this require a deeper investigation.
    Last night I tried to use alter system sql_trace=true and it did not work
    either.
    I had to put sql_trace=true in init.ora and to bounce the database.

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Thursday, October 03, 2002 8:18 PM

    All Im trying to run the following statement

    EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

    And get the following error

    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

    Looking under SYS schema I have package and package body for DBMS_SYSTEM
    and the body includes
    SET_SQL_TRACE_IN_SESSION

    I had to turn on tracing on the database level...
    What could be the matter with this??

    Many Thanks in advance
    bob

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bob Metelsky
    INET: bmetelsky_at_cps92.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Andrea LaBass at Oct 6, 2002 at 5:08 pm
    prefix it with sys.
    ie:
    EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE);


    Yechiel Adar wrote:I think that this require a deeper investigation.
    Last night I tried to use alter system sql_trace=true and it did not work
    either.
    I had to put sql_trace=true in init.ora and to bounce the database.

    Yechiel Adar
    Mehish
    ----- Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Thursday, October 03, 2002 8:18 PM

    All Im trying to run the following statement

    EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)

    And get the following error

    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

    Looking under SYS schema I have package and package body for DBMS_SYSTEM
    and the body includes
    SET_SQL_TRACE_IN_SESSION

    I had to turn on tracing on the database level...
    What could be the matter with this??

    Many Thanks in advance
    bob
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bob Metelsky
    INET: bmetelsky_at_cps92.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Yechiel Adar
    INET: adar76_at_inter.net.il

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    Do you Yahoo!?
    Faith Hill - Exclusive Performances, Videos, & more
    faith.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Andrea LaBass
    INET: alabassus_at_yahoo.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 3, '02 at 6:18p
activeOct 6, '02 at 5:08p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase