Re: Concurrent Problem

gsrnadeem_at_hotmail.com (Gaser Nadeem) wrote:
> Hi All,
>
> I have a Problem in the database concerning the locking record.
> I have an SQL Statement which result in one record and locking it,

In the example you give below, you are selecting and locking all rows, not just one row, that has age>60.

> unfortunately this Statement must be run more than once at the same
> time.
> 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;
>

Xho

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