Re: Execute Immediate Not Working With WHERE CURRENT OF
Date: Thu, 22 Dec 2005 15:15:11 -0500
Message-ID: <ua-dnfgCv-3PlDbeRVn-vQ_at_comcast.com>
"OracleNewbie" <rhythmram_at_gmail.com> wrote in message
news:1135268347.383301.286000_at_g44g2000cwa.googlegroups.com...
> Just for example i mentioned its 5 table it will be more than 100
> tables to choose from. I cant have 100 update statement. Any other way
> to handle it???
>
the design is odd, but i think that has been thoroughly covered in the other posts....
that being said, you can use EXECUTE IMMEDIATE, just don't use the correct syntax (which does not include for current of)
that means you'll need to generate a WHERE clause which has the correct column and predicate condition
have you looked up EXECUTE IMMEDIATE in the docs to check the correct syntax? this will get you started:
EXECUTE IMMEDIATE dynamic_string
[INTO {define_variable[, define_variable]... | record}]
[USING [IN | OUT | IN OUT] bind_argument
[, [IN | OUT | IN OUT] bind_argument]...]
[{RETURNING | RETURN} INTO bind_argument[, bind_argument]...];
++ mcs Received on Thu Dec 22 2005 - 21:15:11 CET