Oracle-L: Re: Help on DBMS_PROFILER required

From: <pradeep_at_ibsplc.com>
Date: Thu, 23 Jan 2003 05:54:33 -0800
Message-ID: <F001.00538537.20030123055433@fatcity.com>

Hi,

Please ask the DBA to check whether the self checking by dbms_profiler was completed.
The package upon completion should give "SYS.DBMS_PROFILER successfully loaded."
Also please grant execute privilege on DBMS_PROFILER to the user .

Pradeep

                                                                                                                       
                    "Satya V Prakash"                                                                                  
                    <prakash801_at_redif        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    fmail.com>               cc:                                                                       
                    Sent by:                 Subject:     Help on DBMS_PROFILER required                               
                    root_at_fatcity.com                                                                                   
                                                                                                                       
                                                                                                                       
                    01/23/03 05:29 PM                                                                                  
                    Please respond to                                                                                  
                    ORACLE-L

Hi,
I need to use the DBMS_PROFILER package for PL/SQL in between the procedures. I used the corresponding script located in
Oracle_home\rdbms\admin\PROFLOAD.sql .
I ran this script, it ran without any problems. But I am still unable to invoke the DBMS_PROFILER package,

The error is

Identifier DBMS_PROFILER.START_PROFILER must be declared ORA-06550
PLS-00201 Any help in this regard would be highly appreciated.

Thanks and Regards,
Satya Prakash

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Satya V Prakash
  INET: prakash801_at_rediffmail.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.net
-- 
Author: 
  INET: pradeep_at_ibsplc.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).

Received on Thu Jan 23 2003 - 07:54:33 CST