Help: Oracle, ODBC, Binding Arrays of Parameters, NULL values

Platform NT4.0, Win95, VisualC++5.0, ODBC SDK 3.0

Problem:
When binding arrays of parameters a problem occurs on INSERT when the FIRST of the elements in the len/ind array specifies a SQL_NULL_DATA element. In this case ALL of the parameter values in the corresponding value array are interpreted as NULL data.The problem only affects the CORRESPONDING value array.

The problem does NOT occur for the second or subsequent elements in the len/ind array. When these are set to SQL_NULL_DATA the corresponding values are correctly set to NULL in the database, but other values are not affected.

During debugging, the parameter set size and the fact that I use parameter arrays have been specified both using the ODBC 3.0 statement attributes, and the ODBC 2.0 parameter options (the driver manager translates one to the other anyway, but just to be sure) In both cases the error occurs.

Of course this is a mess... I can successfully use the array method for NOT NULL datasets, but this is not very nice. The speed-up however is pretty incredible, and I really want to use this method. I am seeing speed improvements of a factor of 3(!!) in a client/server app. (4 hours versus 13...)

anybody has any idea out there??? Please??

if possible, please e-mail me as well, as i am not a regular on these newsgroups

Thanks.

Erik Received on Wed Jun 17 1998 - 00:00:00 CEST