Global Temporary Tables and Crystal

[itprogram]

I'm calling an Oracle SP from Crystal Reports using the ref cursor method. 1 of the tables in the select statement is an Oracle temporary table with delete rows on commit specified and is populated during the procedure.

But the rows do not seem to be deleted for the session until I close crystal and reopen meaning the data duplicates then triplicates etc. Also if I have 2 reports open in crystal and they reference the same temporary tables they can see the records created by the other report.

I would appreciate any information on the correct use of temporary tables and any ideas on the above problem. I don't think my understanding of the tables being session specific is correct. I had presumed that each report on connecting to the database would be a new session but it appears that the session is created at the application level (i.e. the crystal reports application)

 

[dsanchez2]

It sounds like some type of connection polling is been used by Crystal Report. See if there is a way of turning this off, so that report instance connects to its own session.