Testing PL/SQL Source Code
To test PL/SQL code, you must first map the Table Descriptors to the Table instances and check in and install the Program instance and all the Table instances it reads from and writes to.
You can then execute the Program. If the Program writes data to tables, you can check the data; see Viewing Data.
If the Program generates a report, you can see the report in the Reports tab. You can link to the report and the log file from the Job ID link in the Job Executions section of your My Home tab.
Parent topic: Defining PL/SQL Programs