Re: Oracle Bug?

DA Morgan <damorgan_at_x.washington.edu> wrote:
> >
> > The fact that in your example it's an autonomous transaction in the
> > middle isn't really relevant to the SCN - the important bit is it did a
> > commit - this increases the SCN of the database.
>
> I was assuming, obviously incorrectly, that ORA_ROWSCN could be
> used to determine (in a sense) which COMMIT was responsible for
> a specific row.

This is the first time you mentioned ORA_ROWSCN in this thread. It probably can be used to determine which COMMIT was responsible for a specific row.

But I don't think it will read your mind in order to know that that is what you want it to do :)

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB