• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Using connection pool on Oracle 8i temporary tables  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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??
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!