Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     GLOBAL TEMPORARY TABLE in Oracle
Go
New
Search
Notify
Tools
Reply
  
GLOBAL TEMPORARY TABLE in Oracle
 Login/Join
 
Platinum Member
posted
Hi

I have a problem with the Global Temporary Table in Oracle. I am using an application with ColdFusion and WebFOCUS for reporting. After I insert some records to the Global Temporary Table in oracle which is session specific from ColdFusion and then go to WebFOCUS to generate the report based on the inserted records, WebFOCUS is returning zero records. Is there any way for the WebFOCUS to see the records inserted.

Thanks in advance.

Cyril Joy.
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Has Oracle terminated the session before WebFocus is able to read the table?
 
Posts: 26 | Location: Mercy College | Registered: May 06, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It is not the Oracle session that does this. For Global Temporary Table, Table definition and data are session specific. Both get dropped when the session that created the table ends.

In my case ColdFusion session is inserting the records. But this session is getting deleted when I call the Webfocus page.(I am actually submitting the form to WebFOCUS using post method)This is actually making the issue.

So the real issue is how to maintain the session created in ColdFusion to Webfocus after a webfocus request is made..

Please anyone help me in solving this..

Thanks,
Cyril Joy.
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     GLOBAL TEMPORARY TABLE in Oracle

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.