PL/SQL Stored Procedures
A Reports Wand Report Definition can be configured to run a PL/SQL stored procedure before executing the SQL statement associated with the Report Definition.
In order to use this functionality please follow the steps below.
- Create the Reports Wand Database Package
- Create a Stored Procedure
- Assign a Stored Procedure to a Reports Wand Report Definition
Note: The Reports Wand user will be unaware that a Report Definition has a stored procedure linked to it.
Information regarding Stored Procedure Exception Handling