Create a Stored Procedure
The PL/SQL stored procedure must be created in the Reports Wand Database Package.
In order for the stored procedure to be valid it must adhere to the following requirements. If a stored procedure does not adhere to these requirements, it will not be accessible from Reports Wands Administrator for selection.
| Requirement | Description |
|---|---|
| Reports Wand Database Package | The stored procedure must be defined in the XXE4A_REPORTS_WAND_PKG |
| Only IN Parameters | The stored procedure must only have IN parameters defined. No OUT, or IN OUT parameters are allowed |
| Number, Varchar2 and Date datatypes | The stored procedure must only have parameters defined with the following datatypes: NUMBER, VARCHAR2 and DATE |
| No Functions | Any functions defined in the Reports Wand Database Package will be invalid and inaccessible from Reports Wand Administrator |
| Nine Parameters | The stored procedure can have no more than nine parameters. Additionally, the number of stored procedure parameters combined with the Report Definition SQL statement bind variables can also be no greater than nine. |
An example of a valid PL/SQL stored procedure can be found in the Reports Wand Database Package.
Note: There are no parameter naming conventions as long as they adhere to standard PL/SQL parameter restrictions.