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;
/