Topic: SQL*Plus and PL/SQL >> Global Temporary Tables
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Global Temporary Tables |
| ORA |
Posted: May 02, 2007 03:17:39 AM |
Total Post: 1
Joined: May, 2007
|
Hi all!...I am working on Crystal Reports and Oracle.When a report is run it references a prodedure(s) which in turn calls for a Function.The functions returns value from a Global Temporary Table.So this returned Data is displayed in the Report.When the Rpt runs for the first time ,say it displays 10 rows...I then try rerunning the report without logingoff from the same DB Source ,now the report doesnot seem to delete the old data..it displays two sets of data..one old set and another new set so totally 20 rows.When I issue a DELETE * from GTT before I do an insert,an error ORA-06503 is returned, But however when I use TRUNCATE command instead of DELETE, in my function there are no such problems ,infact the report is refreshed between sessions and transactions.Though using TRUNCATE solves the problem ,I dont understand the Logic behind.
Help is appreciated.
Thanks in Advance.
|
|
|
 beefcake |
| Posted: May 10, 2007 05:15:35 AM |  |
|
Total Post: 9
Joined: May, 2007
|
Hi,
it would depend on the definition for your global temporary tables. If your definition is "on commit preserve rows", then as long as you connect on your session you will have the rows available.
But if your definition is "on commit delete rows", then you will have empty table every time you issue commit.
Hope this help.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 334 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
