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

"Tom" <adatrain201te_at_gmx.de> wrote in message news:a80f523.0307240222.3d965054_at_posting.google.com...
> Hi,
> Oracle 8.1.6.0.0
>
> I'm trying to insert into a table with two varchar2(50) columns via
> OCI. The buffer sizes in the OCIBindByPos call are only 31bytes
> for each column. I also set the attributes OCI_ATTR_CHARSET_FORM,
> OCI_ATTR_CHARSET_ID and OCI_ATTR_MAXDATA_SIZE for the bind handles.
>
> OCIStmtExecute returns an error:
>
> ORA-01026 multiple buffers of size > 4000 in the bind list
>
> Does somebody know a solution?
>
> Thanks,
> Tom

Hi Tom, I don't actually use the Oracle 8 OCIs [I'm still using the 7 OCIs as right now I'm too busy (lazy?) to RTFM], but here goes...

My guess is that the 31bytes in the OCIBindByPos is not the DATA buffer size but rather the BIND-NAME buffer size. I would say that you have specified a value for OCI_ATTR_MAXDATA_SIZE (which I think specifies the DATA buffer size) of > 4000 and you have done this more than once.

This appears to be illegal in the 8.1.6 OCIs (based on your error message).

Hope this is some help.

Good Luck, Chris Received on Fri Jul 25 2003 - 20:17:18 CDT