Re: Locking Question (nowait, UPDATE etc)

"Johannes Eggers" <jeggers_at_tetrix.com> wrote:
> <ctcgag_at_hotmail.com> wrote in message
> >
> > I did:
> >
> > create procedure llll (x in number)
> > cursor main is select * from blah where col2=x for update;
> > begin
> > open main;
> > end;
> >
> > then did an exec llll(30)
> > In a separate session, I said "update blah set col1='hi' where col2=30"
> and
> > it blocked until I typed commit in the first session.
>
> I watched our DB guy do the same thing, and we didn't get your result
> (although we expected to).

What version of Oracle? Are you sure blah actually had committed rows where col2=30? (I made that mistake the first time I tried it.)

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB