Home » Developer & Programmer » Reports & Discoverer » how to use Global temporary table (oracle 9i)
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);
|
|
|
|
|
Goto Forum:
Current Time: Sun Jun 01 22:33:31 CDT 2025
|