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!

[@jeffleving3795]

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

[@ravikanth4309]

awesome :)

[@rohanmishra5485]

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

[@oracledatabasedevelopmentt597]

if you have compiled the SP with debug info, you can drill down into the plsql table right there in the variables/watches panel. You can also 'hover watch' a cursor.

[@92mogu]

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?

[@oracledatabasedevelopmentt597]

Mohan Raj version 4 I believe, but the debugger works the same for version 3 as well

[@sayedrahman3932]

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

[@JeffSmiththat]

Something is wrong with your data dictionary - we can't find the information about your program in the database

[@rajeshnedunuri68]

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