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=plus&ref=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).
