Re: Help with simple PL/SQL

From: DFS <nospam_at_dfs_.com>
Date: Thu, 13 Oct 2005 01:25:15 -0400
Message-ID: <Ycm3f.217$lN2.147@fe04.lga>

HansF wrote:
> On Wed, 12 Oct 2005 23:56:18 -0400, DFS interested us by writing:
>
>
>> 14 EXECUTE IMMEDIATE 'UPDATE Table_Project SET ItemOrder =
>> ||i|| WHERE ProjCPID = ||ProjCPID ||';
>
> DO you really want all those concats inside the quotes?
>
> Do you understand what you are concatenating?

I thought I was concatenating the 2 variables into the UPDATE statement. It compiled fine, but threw that error when I ran it.

But I figured it out. The following works like a champ.

14 EXECUTE IMMEDIATE 'UPDATE Table_Project SET ItemOrder = :i WHERE ProjCPID = :ProjCPID' USING i, ProjCPID;

Thanks. Received on Thu Oct 13 2005 - 00:25:15 CDT