Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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: 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).
> >
> >
>
>
>_____________________________________________________________
>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: csvenkata_at_lycos.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: 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).Received on Thu Jan 23 2003 - 20:39:41 CST
![]() |
![]() |