HomeЛюди и блогиRelated VideosMore From: Oracle Database Development Tools

Debugging PL/SQL with Oracle SQL Developer

95 ratings | 40986 views
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!
Html code for embedding videos on your blog
Text Comments (10)
Sayed Rahman (28 days ago)
i cant use this debugging , this is giving me "OBJECT ID":invalid identifier , please help me to solve this
Jeff Smith (28 days ago)
Something is wrong with your data dictionary - we can't find the information about your program in the database
Ravikanth Reddy (1 year ago)
awesome :)
Mohan Raj (1 year ago)
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?
Mohan Raj version 4 I believe, but the debugger works the same for version 3 as well
RoMi (2 years ago)
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
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.
nDestrier (2 years ago)
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.
Rajesh Nedunuri (2 years ago)
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
Jeff Leving (3 years ago)
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...

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.