Debugging PL/SQL with Oracle SQL Developer

Quick overview of our PL/SQL debugger - required privs, setup, and a demo of stepping through a PL/SQL function. Breakpoints, watches, and call stacks, oh my!

[jeffleving]

Wow. I can't believe I'm just now digging just a little deeper into SQLDeveloper to find the debugger. I used debuggers on 3GL code on VAX/VMS way back in the day and they saved my backend so many times. No sense in struggling with in-line output code when this is available for free! Many thanks to Jeff for this tutorial...

[nDestrier]

This was a great post. The video explained how to set the line number, breakpoints, Debugging Port Range, what happens when after compiling a procedure set with Compile for Debug (i.e., Painting Procedure object). Overall this is a excellent video. Despite other comments the cadence of the speaker was perfect.

[poussindupays]

Hi, how can we display the query when there a raise exeption
occurs like trapping :
when others then
dbms_output.put_line(substr(sqlerrm, 1, 255)); ? thx

[mogu]

Pretty much awesome.

Pls let me know the version of the SQL developer?
Also all these options are dependent on oly the Tool not the DB Version isnt it?

[rohanmishra]

How do you see the value of a refcursor while debugging, I can not see the value and mos of my code is with ref cursors, very frustrating

[sayedrahman]

i cant use this debugging, this is giving me "OBJECT ID":invalid identifier, please help me to solve this

[rajeshnedunuri]

The content is very good but the video is very slow. I get sleep when watching this. Could you please talk fast when explaining in the video