ODBC multi-insert problem

ODBC multi-insert problem

Post by asylum54 » Sat, 24 Jul 2004 05:34:38


ODBC has an option for binding an array of parameters.
Are bulk array parameters with procedure calls supposed to work? A
plain insert works.

"insert into sometable values (?)" works with bulk array parameters.

"{CALL myproc(?)}" fails with bulk array parameters with error
"Invalid application buffer type".

The myproc call works fine with one parameter at a time.

Note, I am doing a prepare first, then binding an integer array. The
failure occurs on the bind call.
Are there any examples available?

client 2.81 ODBC driver: 3.82
server: IDS 9.4
ODBCExpress v5.06

Thanks, Rob.