Re: Insert with "nowait" - workaround.

Try dbms_lock

NIKOS OIKONOMOU <unixfor_at_ath.forthnet.gr> wrote in article <35446447.2E661096_at_ath.forthnet.gr>...
> Please help us on the following problem
>
> Table A has two fields. Field pk is a primary key and field uk is a
> unique key.
> A session inserts into A the record (pk_val1, uk_val1) successfully.
> The session does not commit the insertion.
> Another session attempts to insert the same record
> and because there is the uncommitted previously inserted record from
> another session the second session has to wait until the first session
> execute a commit or a rollback releasing the row-lock.
>
> We want to change the above scenario. What we want is to make each
> session attempting to insert a record to be able to understand that at
> the specific moment a row-lock for the specific row exists and abort the
> insertion immediately.
>
> We may say that we need a 'NOWAIT' behavior for the insert operation.
>
> Which is the best method we can accomplish what we need? (We are looking
> for a work-around).
>
> Thank you very much.
> Nicolas Economou
>
>
>
>
  Received on Mon Apr 27 1998 - 00:00:00 CDT