If additional logging is necessary for debugging purposes, the package can be compiled with the DEBUG parameter equal to ‘YES’. Depending on the procedure, this can result in a very verbose execution that contains state change information and call stack details and other background call details to assist with debugging certain issues.
-- Enable/Disable Additional Debugging Information.
-- 'YES' = Enable Debugging Output During Execution
DEBUG VARCHAR2(3) := UPPER('YES');