Update question

From: <terry_stjean_at_my-deja.com>
Date: Wed, 30 Aug 2000 17:07:20 GMT
Message-ID: <8ojevl$pqh$1_at_nnrp1.deja.com>

[Quoted] 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 - 19:07:20 CEST