RE: Is there anything called session specific tables

From: Dasko, Dan <Dan.Dasko_at_cdicorp.com>
Date: Fri, 16 Mar 2001 09:57:46 -0800
Message-ID: <F001.002CEE34.20010316063122@fatcity.com>

I'm not sure I understand. Are both sessions updating the same data, or are they inserting new data? Or is the situation that A updates a row and expects to see that in the report and yet B updates the data to a different value before A's report runs and A cannot understand why his report didn't work out the way he expected?

I guess that I wonder about having multiple users updating the same data and then expecting a report to only show what they did. Now, if you can change things around so that each user puts stuff in a unique row, then viola, problem solved. Otherwise, you could maybe gather the data to be inserted and combine it with the data selected for the report and then after the report was run, then update the table.

Dan's $.02

-----Original Message-----
Sent: Friday, March 16, 2001 2:36 AM
To: Multiple recipients of list ORACLE-L

Hello Listers,

I am facing a typical problem. In one of my D2K appliaction I need to first populate the data in a particular itermediate table and then run the reporting job. The data population has been done in the report trigger. But the problem is if at the same time another user fires the same report, the data population becomes erroneous as he is also sharing the same table.

Is there any concept of session specific tables.

Please help.
Regards,

Tapas

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: tapas dutta
INET: tapasoracle_at_umtl.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dasko, Dan
INET: Dan.Dasko_at_cdicorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------