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

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic SQL, Method 4 Question

Dynamic SQL, Method 4 Question

From: Jason Botwick <sophie_at_interpath.com>
Date: Wed, 05 Jan 2000 02:48:55 -0500
Message-ID: <sophie-0501000248560001@sanford1a-0051.dyn.interpath.net>


I'm trying to use dynamic SQL method 4 (unknown # of bind variables) in Pro*C where the bind variables are host arrays. The problem seems to be that you can't specify a value length or an indicator value for each row in a host array. You can only specify one length and one indicator value for the whole array. What are the consequences of this, does anyone know? What if some of the values are too short/too long or NULL?

Thanks,
Jason Received on Wed Jan 05 2000 - 01:48:55 CST

Original text of this message

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