Debugger in Test window

[Vinny]

When attempting to run something through the test window, I never get the chance to step through the code. After F9, the code just runs, never getting to the point where I can click the step into icon (ctrl-n).

Is this how the user was setup? The user I am logged in as is also the owner of the package I am trying to run in debug.

My script:
DECLARE
myclob CLOB;
BEGIN

SELECT * INTO myclob
FROM xml_reader;

xmlreader.parse( myclob );

END;

Thanks.

 

[rbrooker]

Hi,

try right clicking in the package, choose "Add debug information" and then debug the package.

 

[Vinny]

That did it. I guess I now understand what the downside of unchecking "add debug information when compiling" is. Thanks.

 

[Mic R. W. Buchanan]

The debug information is in my package, but I am having the same difficulty. Any ideas??

 

[F. van Boven]

Make sure you use the "Start debugger" instead of the "execute"...

(It's not clear what you are using (F9) since I've scrambled all my shortcuts.)

 

[peter49]

We've had similar problems after upgrading from Oracle 9i to 10g. The problems went away after granting "debug connect session" and "debug any procedure" system privileges. They weren't required in 9i.

 

[ruzhansky]

We have same problem like Peter49. Please help us!

 

[Marco Kalter]

Just grant the system privileges he mentions to fix it. This is a 10g requirement.