Was the package created with the sys or internal userid? Did you ran
proftab.sql and profref.sql. proftab.sql creates a copy of the profiler
tables in your own schema. profref.sql creates views and packages to operate
on the profiler tables in order to generate reports, it should be run in
your own schema.
-----Original Message-----
From: Satya Prakash [mailto:satyaprakash_v@xxxxxxxxxxx]
Sent: Thursday, January 23, 2003 7:11 AM
To: Oracle
Subject: [oracle] Help on DBMS_PROFILER needed
Hi All,
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 package, 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 V
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx
|
