Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why my dynamic sql statement failed?
On 15 Feb 2006 13:32:08 -0800, zlmei_at_hotmail.com wrote:
>. Anyone know why?
string literals can't continue across linefeeds. It should have been execute immediate 'UPDATE <blabla> '||
'set foo = bar '|| 'where 1=1';Also there needs to be a space between immediate and the single quote.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Feb 15 2006 - 15:47:38 CST