how to use Global temporary table [message #645436] |
Sun, 06 December 2015 23:40 |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
I create this global temporary table and create a form, where I am calling report through a push button but report isn't showing records.
Kindly advise me, how to use global temporary table in reports.
-------------------------
-- GLOBAL TEMPORARY TABLE
-------------------------
create global temporary table PROD_INV
(
WDATE DATE,
DOCNO VARCHAR2(10),
CUSTM VARCHAR2(7)
)
on commit preserve rows;
-----------------
-- CALLING REPORT
-----------------
Run_Product(REPORTS, :Global.Report_Path || 'SD_PRODINV', ASYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);
|
|
|