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

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.

> <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.