global temporary table [message #387859] |
Fri, 20 February 2009 23:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
Hi,
Can we create a temporary global table at backend and populate it in our report ?
I did tht.... my report works fine...i have given the populate code in after parameter form.... bt the problem z report works fine on the first run...if i again run the parameter form it does nt show anything....And i have to close the full report builder,re-open and again run....
What 2 do ?
Thanks and regards.
Charu.
|
|
|
|
Re: global temporary table [message #387930 is a reply to message #387914] |
Sat, 21 February 2009 22:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
sorry for the abbreviations
my script for global temporary table is :
creating global temporary tables
1 create global temporary table lib_bk_class_tmp(
2 class_no VARCHAR2(20),
3 BOOK_NAME VARCHAR2(200),
4 author_name VARCHAR2(50),
5 PUBLISH_DATE NUMBER(4),
6 CLASS_TYPE VARCHAR2(10),
7 serial NUMBER(10),
8 book_counter NUMBER(4),
9 book_id NUMBER(10)
10* )on commit delete rows
even if i tried on commit preserve rows nothing changed...it was still executing just once .....then i had to exit report builder and reopen....
But if i create a form and call that report then it works fine....i get all the labels...
So problem solved other way round.
Thanks.
Charu.
|
|
|
Re: global temporary table [message #387944 is a reply to message #387930] |
Sun, 22 February 2009 04:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
hi !
what if i want to call the report directly instead of form forms ?
where do i create the global tempoarry table so that it is acessible between parameter form runs......
thanks.
charu.
|
|
|
Re: global temporary table [message #387971 is a reply to message #387944] |
Sun, 22 February 2009 13:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Quote: | where do i create the global tempoarry table
|
In the database, of course.
Tables in an Oracle database, which includes global temporary tables, should be pre-created (i.e. not created, dropped, created, dropped, ... as some databases do). In order to do that, create them as you already did: using SQL*Plus.
|
|
|