On Demand Crystal Report and 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,
Oracle will return the records defined by the selection criteria as they are at the time of the session connection -
There is no duplication involved,but, since the records are already in the Global Temp Table ( usually not a good thing to use in Oracle, by the way) the data displayed will be the same if the criteria is the same.






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

 

[rb2005]

What is a good thing then? Regular temp table? Let me know what is the best solution.

 

[Turkbear]

Hi,
Why a TEMP anything?

If you want to recreate/update the data on some regular basis, just delete/insert using your SP and a standard table.

You could also create a view for report access and update the underlying table(s) on a regular basis..





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