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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
