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_at_sanford1a-0051.dyn.interpath.net>
[Quoted] 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?
Date: Wed, 05 Jan 2000 02:48:55 -0500
Message-ID: <sophie-0501000248560001_at_sanford1a-0051.dyn.interpath.net>
[Quoted] 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 - 08:48:55 CET