Re: Help with simple PL/SQL

From: HansF <News.Hans_at_telus.net>
Date: Thu, 13 Oct 2005 04:05:06 GMT
Message-Id: <pan.2005.10.13.04.03.48.696783@telus.net>

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?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Wed Oct 12 2005 - 23:05:06 CDT