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@redif        To:     Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>       
                    fmail.com>               cc:                                       
                                
                    Sent by:                 Subject:     Help on DBMS_PROFILER 
required                               
                    [EMAIL PROTECTED]                                                   
                                
                                                                                       
                                
                                                                                       
                                
                    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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to