I am trying to debug a stored procedure using Oracle SQL Developer. The DB is on another box. I have granted privileges using
GRANT debug any procedure, debug connect session TO <user>;
I have placed the break point inside the procedure on one of the assignment lines. I have tried other places too out of desperation. When I click debug I get the debug dialog and I fill in all the values. When I hit debug the stored procedure runs, the debug controls flash across the screen in a second and then it finishes and exits. It misses all the breakpoints as if it weren't even there. Any ideas?
For debugging to work you have to compile the Package / Procedure with the Debug-Flag. In SQL-Developer this is done by opening the package and clicking on the little "Gears with a bug"-Button (Compile Package for Debug)
After that all your breakpoints will work.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With