Re: Execute Immediate Not Working With WHERE CURRENT OF
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 21 Dec 2005 21:05:52 -0500
Message-ID: <MrmdnabhnZGflzfenZ2dnUVZ_t6dnZ2d_at_comcast.com>
Date: Wed, 21 Dec 2005 21:05:52 -0500
Message-ID: <MrmdnabhnZGflzfenZ2dnUVZ_t6dnZ2d_at_comcast.com>
<rhythmram_at_gmail.com> wrote in message
news:1135199201.635061.117440_at_g47g2000cwa.googlegroups.com...
> Hi Bakker Thanks for your reply.
> What will be the code if i have the table name as dynamic like..
>
> for c1_rec in c1 loop
> ## some logic to get strTECH value ####
> update "DYNAMIC TABLE NAME" set subsec = strtech
> where current of c1;
> end loop;
>
CURRENT OF implies the current row in the referenced cursor
if you table is dynamic (i think your other post mentions up to about 5 different tables) then the update is not always (if ever) going to target the same table as the cursor, is it?
likely that's why it's an unsupported feature
++ mcs Received on Thu Dec 22 2005 - 03:05:52 CET