Debugging PL/SQL Code
Debugging PL/SQL code in the database can be done by placing breakpoints on the required line(s) of the source code fetched from the database.The source code can be fetched from the database in different ways depending on the context. The database method to be debugged can be called either by a remote client (IFS EE) or by using a test PL/SQL block generated by the tool
Note: In order to debug a database package it should be compiled with the 'DEBUG' option.
Example: ALTER PACKAGE <PACKAGE_NAME> COMPILE DEBUG;
Read more about different debugging scenarios: