Reports Wand Database Package
In order to use PL/SQL Stored Procedures with Reports Wand a custom database package must be created on your Oracle E-Business Suite Database.
It’s important to understand the implications of creating custom database objects on your E-Business Suite Database before creating this database package.
To create the Reports Wand database package execute the following script on your Oracle E-Business Suite Database. Once the database package has been created you will be required to launch Wands again.
This database package script contains an example PL/SQL stored procedure. The example stored procedure can be commented out or removed from the database package when required.
APPS.XXE4A_REPORTS_WAND_PKG
CREATE OR REPLACE PACKAGE APPS.XXE4A_REPORTS_WAND_PKG AS /* Example Reports Wand Stored Procedure */ PROCEDURE XXE4A_TEST_PROC( param1 NUMBER, param2 VARCHAR2, param3 DATE); END XXE4A_REPORTS_WAND_PKG; / CREATE OR REPLACE PACKAGE BODY APPS.XXE4A_REPORTS_WAND_PKG AS /************************************************************* * NAME: XXE4A_TEST_PROC * ARGUMENTS: PARAM1 Number * PARAM2 Varchar2 * PARAM3 Date * DESCR: Example Reports Wand Stored Procedure **************************************************************/ PROCEDURE XXE4A_TEST_PROC( param1 NUMBER, param2 VARCHAR2, param3 DATE) AS temp_number NUMBER; temp_text VARCHAR2(240); temp_date DATE; BEGIN temp_number := param1; temp_text := param2; temp_date := param3; END XXE4A_TEST_PROC; END XXE4A_REPORTS_WAND_PKG; /