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).