Using debug is not stopping on breakpoints in Oracle SQL Developer

Question

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?

Falco · Accepted Answer · 2015-02-05 08:35:12Z

15

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.

answered Feb 5, 2015 at 8:35

Falco

3,46626 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hoàng Long Over a year ago

Correct cause for my case

uriDium · Accepted Answer · 2009-12-28 14:11:18Z

2

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

answered Dec 28, 2009 at 14:11

uriDium

13.5k21 gold badges82 silver badges146 bronze badges

1 Comment

Falco Over a year ago

This answer will probably not help others in your situation much, I think when you changed something and saved -> saving a Stored Procedure in SQL-Developer actually compiles it in the Database -> See my answer

Collectives™ on Stack Overflow

Using debug is not stopping on breakpoints in Oracle SQL Developer

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related