RE: Help on DBMS_PROFILER needed

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:[email protected]]
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 [email protected].