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
8 жыл бұрын
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
4 жыл бұрын
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
@rohanmishra5485
7 жыл бұрын
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
7 жыл бұрын
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.
@sayedrahman3932
5 жыл бұрын
i cant use this debugging , this is giving me "OBJECT ID":invalid identifier , please help me to solve this
@JeffSmiththat
5 жыл бұрын
Something is wrong with your data dictionary - we can't find the information about your program in the database
@ravikanth4309
7 жыл бұрын
awesome :)
@92mogu
7 жыл бұрын
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
7 жыл бұрын
Mohan Raj version 4 I believe, but the debugger works the same for version 3 as well
@rajeshnedunuri68
8 жыл бұрын
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
Пікірлер: 11