SEO

#1 (**permalink**) 02-24-2008, 02:21 PM

Hi guys,
I had the DBA install DBMS_PROFILER in one of our 9.2 databases,
including the 3 corresponding tables in my own schema, but every time I
try to use it, I receive:

SQL> begin
2 dbms_profiler.start_profiler('Test');
3 null;
4 dbms_profiler.stop_profiler;
5 end;
6 /
begin
*
ERROR at line 1:
ORA-06528: Error executing PL/SQL profiler
ORA-06512: at "SYS.DBMS_PROFILER", line 123
ORA-06512: at "SYS.DBMS_PROFILER", line 132
ORA-06512: at line 2

The source code being rapped, I can't see much as to what's on those
lines (123 and 132). Anyone has an idea?

Daniel

#2 (**permalink**) 02-24-2008, 02:21 PM

Don't worry about it guys, I found note 117775.1 on metalink, which
says that the tables have to be created in the same schema running the
package.

Daniel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Problem Having DBMS_PROFILER Working