Using connection pool on Oracle 8i temporary tables
posted 14 years ago
Hi all, In ORACLE 8i, for temporary tables and cursors, after creation if we are incrementally trying to query the temporary table or cursor (in profile reports), there is no guarantee that we will get the same connection as the one we got for the first time because we are using pooled connections from the middle tier. This could lead to data integrity issues. To solve this problem, we have to go for permanent tables OR file system which are costly operations. We would like to know whether there is any alternative solution to overcome this problem. Probably, we can check whether anybody else has faced a similar problem in the past and what was done to solve the same. Can materialised views in ORACLE 8i be used for this purpose ? Can anybody help??