Possible to update > 1 tables in CURSOR...FOR UPDATE ?

From: R Chin <rchin_at_panix.com>
Date: Sat, 4 May 2002 16:32:41 -0400
Message-ID: <ab1gdk$6vm$1@reader1.panix.com>

8.1.7/AIX
I am trying to do this with no luck.....

Update both of 2 tables joined in a CURSOR..FOR UPDATE using the WHERE CURRENT OF clause....
is this doable ?

as the following shows but doesn't work:

DECLARE
  CURSOR my_cursor
  IS
  SELECT a.col_y,

                   b.col_z

  FROM
  TA a, TB b ---< 2 table join
  WHERE a.col_x = b.col_x
  FOR UPDATE OF col_y, col_z

BEGIN
...
...

FOR i IN my_cursor
LOOP

• Update TA UPDATE TA SET col_y = 'whatever' WHERE CURRENT OF my_cursor;
• Update TB UPDATE TB SET col_z = 'whatever' WHERE CURRENT OF my_cursor;

END LOOP;

---

Thanks
Rob Received on Sat May 04 2002 - 15:32:41 CDT