Re: Execute Immediate Not Working With WHERE CURRENT OF
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 22 Dec 2005 19:17:24 +0100
Message-ID: <doepvi$hvp$2_at_news6.zwoll1.ov.home.nl>
>
>
> "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.
Date: Thu, 22 Dec 2005 19:17:24 +0100
Message-ID: <doepvi$hvp$2_at_news6.zwoll1.ov.home.nl>
DA Morgan wrote:
> 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;
>
>
> "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.
Judging from the way the OP mixes first and last names (Hi Bakker, when responding to Sybrand), me thinks it's the code base for Apps, sorry, eBS 12G he's working on.
Being outsourced, of course, to China, within two years.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Dec 22 2005 - 19:17:24 CET