I realized I didn’t have a good video demonstration of the debugger, so I decided to fix that. If you have 8 minutes to spare, take a look at how this might be more useful to you than using DBMS_OUTPUT or inserting other artificial code.
Here are some slides if you prefer…
2 Comments
Hi Jim, nice video.
Could you please explain which prerrequisites are needed in order to enable debug in Oracle database from SQL Developer. I mean do I need to compile any package in the database or enable some specific port?
Your video shows that the debugger is running DBMS_DEBUG_JDWP.CONNECT_TCP(…) procedure. Is this a built in package or do I need to manually compile it?
Thank you
Jose
Everything you need to know here.