Re: Is it possible to timeout in PRO*C/C++?

Thanks Galen.

Galen Boyer <galenboyer_at_yahoo.com> wrote in message news:uy9sdvnl2.fsf_at_primix.com...
> On Thu, 3 May 2001, ygao_at_mindspring.com wrote:
>
> > 2. Is there a simple way (query) to get the first unlocked row
> > in PRO*C/C++ ?
>
> I don't really get this one. Are you expecting to work on a set
> of rows and you want to know when any one of those comes free?
> That's seems even harder than your next requirement.

This is also row locking related. When some rows are locked, I'd like to select the other unlocked rows for update. Trying to update a locked row or select a locked row for update causes my app stuck.

>
>
> > <Wished there were a pseudo-column like ROWID to tell if a row
> > is locked -:) >
> >
> > =Note: The way I can think about is using a read only Cursor
> > and 'SELECT <specific row>... FOR UPDATE NOWAIT' to test if
> > the row is locked.
>
> I think both are equivalent although I don't know if the rowid
> thing exists. I'm quessing there is some way to query some V$
> table and get that a specific row is locked, but I couldn't find
> it after digging around a bit. I would have used the second
> option and as I said, they both would solve the same thing.
> --
> Galen
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.
Received on Fri May 04 2001 - 07:14:57 CDT