Re: PL/SQL and multiple UPDATE

From: Steffen Göck <stevie-g_at_gmx.de>
Date: 2000/04/23
Message-ID: <8dvdhc$h9m$1@news05.btx.dtag.de>#1/1

Eckhard Kirschning <kirschni_at_uke.uni-hamburg.de> schrieb in im Newsbeitrag: 3902ED9F.243141B0_at_uke.uni-hamburg.de...

RTFM :-)
>
> PROCEDURE proc(parameter_list)
> IS
> CURSOR update_cur IS
> SELECT a,b,c,d
> FROM t_table
> WHERE column=v_in
> FOR UPDATE;
> update_rec update_cur%ROWTYPE;
> BEGIN
> OPEN update_cur;
> FETCH update_cur INTO update_rec;
>

   UPDATE t_table
   SET a=v_1_in,

           b=v_2_in,
           c=v_3_in,
           d=v_4_in

   WHERE CURRENT OF update_cur;
>
> CLOSE update_cur;
> END proc;
Received on Sun Apr 23 2000 - 00:00:00 CDT