Re: Update question
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 30 Aug 2000 21:52:37 +0200
Message-ID: <967667069.974.0.pluto.d4ee154e_at_news.demon.nl>
Date: Wed, 30 Aug 2000 21:52:37 +0200
Message-ID: <967667069.974.0.pluto.d4ee154e_at_news.demon.nl>
All records satisfying the query criteria are locked before you fetch, so in your case all records of this table/view.
Hth,
Sybrand Bakker, Oracle DBA
<terry_stjean_at_my-deja.com> wrote in message
news:8ojevl$pqh$1_at_nnrp1.deja.com...
> I have a procedure which uses a cursor defined as follows:
> CURSOR rev_pos_sales_cursor IS
> SELECT prodid, upc
> FROM rev_pos_sales FOR UPDATE;
> When I do a fetch, are all the records locked for update or is only the
> one record I fetch locked?
>
> Terry
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 30 2000 - 21:52:37 CEST