Using the PL/SQL Debugger - Philipp Salvisberg

Every developer knows the problem. An application doesn't do what it should and the existing logging output doesn't help. Usually, the presumed defective program area is iteratively extended by further logging calls to locate the error. If this is of no use, a colleague is called in. Maybe he has an idea. In such cases I recommend using the PL/SQL debugger. The debugger not only helps to find the error faster but is also an excellent tool to display the context of a concrete use case and to better understand the program.

In this presentation I explain among other things

- the prerequisites for using the PL/SQL Debugger,
- the difference between DBMS_DEBUG and DBMS_DEBUG_JDWP,
- how both debugger variants can be used in SQL Developer,
- and how debugging works directly from an application without adapting the source code.


A recording provided by the awesome APEX community, that built a virtual 24 hour conference called APEX@Home held on April 16th 2019.


With 24 world renowned speakers and nearly 5000 virtual attendees, this event was a huge success. You can check out all the sessions recordings at:

https://apexatho.me

Oracle APEX - Build enterprise apps 20x faster with 100x less code

https://apex.oracle.com



picture credit: https://pixabay.com/users/Brett_Hondow-49958/


 #lowcode #apex