Re: Execute Immediate Not Working With WHERE CURRENT OF

On 21 Dec 2005 12:00:08 -0800, "rhythmram_at_gmail.com" <rhythmram_at_gmail.com> wrote:

> FOR c1_rec IN c1 LOOP
> #### SOME LOGIC WILL MODIFY THE strTech VALUE ###### AND THEN
>UPDATE
> EXECUTE IMMEDIATE ' UPDATE TESTTABLE SET SUBSEC = ' ||
>strTech || '
>WHERE CURRENT OF c1';
> END LOOP;
for c1_rec in c1 loop
updat testtable set subsec = strtech
where current of c1;
end loop;

You don't need NDS at all in this context, or your goal must be to write unscalable code.

--
Sybrand Bakker, Senior Oracle DBA