Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reasons why PL/SQL Developer's debugger won't enter a procedure?

I am trying to debug a procedure using PL/SQL developer's built-in debugger.

After stepping over the BEGIN, when the debugger is over the actual procedure call, the "step-into" button will just execute the procedure without entering it.

Any suggestions would be appreciated.

like image 408
Nico Mezeret Avatar asked Mar 30 '16 16:03

Nico Mezeret


People also ask

How do you debug a procedure in Oracle PL SQL Developer?

Right-click the PL/SQL object that you want to debug and select Database Tools | Recompile. In the Recompile dialog, select With "debug" option. Click OK.

How do you debug a procedure?

Click the left window margin to add a breakpoint to the EXEC statement. Press the drop-down arrow on the green arrow button in the Transact-SQL editor toolbar and select Execute with Debugger to execute the query with debugging on. Alternately, you can start debugging from SQL Server Object Explorer.


1 Answers

Try adding debug information like @Carlo Sima mentioned.

Like this:

Add debug information

like image 169
Marco Avatar answered Oct 14 '22 16:10

Marco