Re: Execute Immediate Not Working With WHERE CURRENT OF

rhythmram_at_gmail.com wrote:
> 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;

[Quoted] "DYNAMIC TABLE NAME" ... bad construct.

Get someone that understands databases to help you with your design. What you have here is a disaster waiting to happen.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)