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!
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...
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.
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
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?
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.