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.

Has Oracle terminated the session before WebFocus is able to read the table?

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.