Re: Help: Package Cursor Problem: Invalid Column?

You may want to use the WHERE CURRENT OF clause in your loop

e.g

LOOP
UPDATE myr_t
SET prf = rtd_cur.intro_prf
WHERE CURRENT OF logic_test_cur ;
END LOOP;
COMMIT; HTH, Mark

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT