Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: two sessions inserting/updating the same table

Re: two sessions inserting/updating the same table

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 17:10:47 GMT
Message-ID: <3C752A2B.5EE6A258@ci.seattle.wa.us>


"Is there a better way?" you ask?

Yes.

Rearchitect it. It is not going to work ... ever. At least not without the most convoluted, strained, and tortured code imaginable.

Why can't session2 pass its values as parameters to session1?

Daniel Morgan

Tim wrote:

> Hi,
> This must be a very common dBase issue but I don't know what the
> answer is:
>
> I've got two sessions accessing the same table. They are entering
> values into seperate fields to make a complete entry. If Session1 sees
> a half completed entry it UPDATEs the row otherwise it INSERTs in a
> new row. Session2 does likewise.
>
> But obviously if Session2 querys the table after Session1 has INSERTed
> but before its COMMITted I'm going to get two partial entries.
>
> I've got a crude solution involving a second table but is there a
> better way?
> thanks
>
> Tim
Received on Thu Feb 21 2002 - 11:10:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US