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: Execute Immediate with variable qty bind params

Re: Execute Immediate with variable qty bind params

From: <frank.sconzo_at_gmail.com>
Date: 14 May 2006 13:46:41 -0700
Message-ID: <1147639601.528077.176410@u72g2000cwu.googlegroups.com>


Sybrand,

Thanks again. Using NVL in the update statement with the bind parameters looks interesting, but yes, messy. I will use your suggestion to select for the id, catching the NO_DATA_FOUND exception and setting an insert flag.  

Cheers,
Frank Received on Sun May 14 2006 - 15:46:41 CDT

Original text of this message

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