A simple, essential part of PL/SQL coding and debugging is logging. However, it seems to be one of the most overlooked parts of coding. Below is a simple package body (the package is left out for brevity) and the DDL needed for it:
Viewing entries tagged
PL/SQL debugging