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.
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.
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.
Try adding debug information like @Carlo Sima mentioned.
Like this:
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