Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Using debug is not stopping on breakpoints in Oracle SQL Developer

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?

like image 750
uriDium Avatar asked Dec 28 '09 12:12

uriDium


1 Answers

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.

like image 146
Falco Avatar answered Oct 24 '22 18:10

Falco