Re: ORA-01026 Multiple buffers of size > 4000 in the bind list.

Telework <kien.tran_at_pwgsc.gc.ca> wrote in message news:<3B460C2C.7CBFD688_at_pwgsc.gc.ca>...
> This error occur when one of our newly upgraded software use Microsoft
> ODBC to connect to our Oracle8i database. We use Microsoft ODBC for
> Oracle version 2.573.4403.00 and Oracle 7.3.4 client. The software
> vendor suggest that we upgrade the Oracle client to 8i version. That
> solution proves to work well however because of the corporate policy
> prevent me from implementing it. Please help if you know a fix that make
> our current client setup to work with Oracle8i database.

I don't believe this can be made to work with the Microsoft driver. The Microsoft driver doesn't support multiple LONG columns (not even sure it supports a single LONG column). The Oracle8 driver does have code that supports this construct.

I believe your only options are to change the client configuration, or to deal with only one LONG column at a time (assuming Microsoft's driver does support single LONG columns).

Justin Received on Mon Jul 09 2001 - 16:24:29 CDT