Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Distinguish committed data from other transactions and uncommitted data from my transaction in a database table.
<ctcgag_at_hotmail.com> schrieb im Newsbeitrag news:20040113111925.224$uP_at_newsreader.com...
> Galen Boyer <galenboyer_at_hotpop.com> wrote:
> > On 12 Jan 2004, manfred.bauer4711_at_gmx.de wrote:
> > > Hello,
> > >
> > > I have the following problem: I have an interace table ordedata
> > > with a a sequence number to determine the sequence of the data.
> > > The table looks like this: ordecode orderow, .. seqnbr
> > > (sequence number )
> > >
> > > I have now a transaction, which writes one or several rows into
> > > that table.
> > >
> > > What I want is the following: At the beginning of the
> > > transaction I am selecting the highest sequence number for the
> > > data for a specific order and store it in a global
> > > PL/SQL-Variable.
> > >
> > > At the end of the transaction, I want to get again the highest
> > > sequence number in the table for my order.
> > >
> > > Now I want to find out in my transaction, if some other
> > > transaction have written also data in that table.
If you just want to make sure the sessions get proper and unique sequence
numbers, why not define a sequence?
Lots of Greetings!
Volker
Received on Tue Jan 13 2004 - 10:24:04 CST