Help on DBMS_PROFILER required
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).
Re: Help on DBMS_PROFILER required
Run GRANT EXECUTE ON SYS.DBMS_PROFILER TO you first; it appears that your permissions were granted through a role... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:59 AM 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: Tim Gorman 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).
Re: Help on DBMS_PROFILER required
Satya, pls grant the privileges from sys to the user running the DBMS_PROFILER package Venkat -- On Thu, 23 Jan 2003 03:59:00 Satya V Prakash wrote: 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). _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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).
Re: Help on DBMS_PROFILER required
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@redifTo: 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).
Re: Re: Help on DBMS_PROFILER required
Hi Venkat and group, Thanx for ur replies, It worked !! U were right. I now connected as sys and granted permission for my user, ran the script(PROFTAB.sql), The table- plsql_profiler_data is now created ! Regards, Satya Prakash On Thu, 23 Jan 2003 C.S.Venkata Subramanian wrote : Satya, pls grant the privileges from sys to the user running the DBMS_PROFILER package Venkat -- On Thu, 23 Jan 2003 03:59:00 Satya V Prakash wrote: 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). _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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: 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).