debugger not stepping into

lcoriddi

Member
I am not able to step into my code...when testing, it just runs the whole procedure to the end. I want to be able to see the variables as they get set.

I have searched and found the following:
The procedure (or the package containing the procedure) might not be compiled with debug info---the checkbox for 'Add debug information' is set and I have the "Use DBA views if available" preference enabled

2) the user running the debugger is not the owner of the package/procedure
(you need the "debug any procedure" privilege to debug procedures you don't own)

Where do I find this to set it?
"debug any procedure" privilege


Thank you
 

So these are the 2 grants that should give me access to use the debug function.
grant DEBUG CONNECT SESSION to ;
grant DEBUG ANY PROCEDURE to ;

I was able to get it working...I used it for a couple of hours....then for some reason it stopped. Any ideas why?
 
Was the program you are debugging compiled for debug?
Alter compile debug
or right-click the object and 'add debug information'
 
Back
Top