Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: why my dynamic sql statement failed?

Re: why my dynamic sql statement failed?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 15 Feb 2006 22:47:38 +0100
Message-ID: <l887v15iqimd8862uercvbp9g9c0tmmo50@4ax.com>


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 DBA
Received on Wed Feb 15 2006 - 15:47:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US