Re: Concurrent Problem

On 11 Apr 2003, gsrnadeem_at_hotmail.com wrote:
> Hi All,
> so i need a solution the ignore the locked recored and go to
> the next one .
>
> Ex.
> select emp_name
> from employee
> where Age > 60
> for update of emp_status;

Add a nowait clause, check the return condition and when you actually get an unlocked row, work on it.

-- 
Galen Boyer