Oracle Temp Table

[rb2005]

Hi,
I am planning to store data in Oracle 9i global temp table and retrieve report data from there. I will write Oracle Stored Procedure to insert data into temp table. I will use Crystal 10 for reporting. Now these reports are mostly daily and on demand. User can see data for any day. So basically they will pass date parameter and get the report. I have only one concern if two users try to see the same report at same time and for the same date will they see duplicate data or Oracle will consider that as two request as two different session?

If any one has any clue please let me know. Thanks in advance.
RB

 

[Turkbear]

Hi,
See my reply in the Business Objects forum, but basically, no duplication is involved - if both users use the same criteria, they will see the same output.





To Paraphrase:"The Help you get is proportional to the Help you give.."