Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Help on DBMS_PROFILER required

Re: Re: Help on DBMS_PROFILER required

From: Satya V Prakash <prakash801_at_rediffmail.com>
Date: Thu, 23 Jan 2003 18:39:41 -0800
Message-ID: <F001.005392B0.20030123183941@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US