Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Execute Immediate with variable qty bind params
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