CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
uriDium
uriDium

Reputation: 13440

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?

Upvotes: 9

Views: 11219

Answers (2)

Falco
Falco

Reputation: 3446

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.

Upvotes: 15

uriDium
uriDium

Reputation: 13440

Okay, found the answer by accident. Turns out after I altered the proc slightly (added debugs) and the saved then it started working.

Upvotes: 2

Related Questions