Re: ORA-01026: multiple buffers of size > 4000 in the bind list (Shrink wrap software)

I had this problem recently.

If I remember aright, it was caused by using a varchar(4000) column with an odbc driver that understood oracle varchar columns to go to only 2000 characters. The solution was to change the column data type to varchar2(2000) - it didn't make any difference to my app.

You may find that you can use e.g. an MS odbc driver in place of the oracle one or vice-versa, with the usual caveats about the unreliability and inconsistency of odbc drivers.

macknox <Kevin_at_curryingflavor.com> wrote in message news:c18594ab.0201150514.61566767_at_posting.google.com...
> Hello All,
>
> I'm a Java/Notes developer working on a shrink wrap product (Archibus)
> connecting to an Oracle back end database. I'm a fish out of water, so
> any help I can get will be appreciated.
>
> To all appearances, the Archibus developers are using bind lists, and
> binding them inappropriately. Except that they have a number of
> successful installs of this product at other companies. This is a
> problem unique to our installation, but we can't figure out what we
> are doing wrong, and neither can they. We have exhausted their tech
> support options.
>
> Our Oracle DBA group has exhausted their options as well. Our servers
> are at 8.1.7.2 while our clients are at 8.0.5. Being rather a large
> company, we cannot upgrade our clients to 8.1.7, and we aren't event
> sure whether this would fix the problem. We are certain that if we
> upgraded to 8.1.7, another critical application would break.
>
> Finally, every Win NT 4 box we have produces this error, while every
> Win2000 box we have works perfectly. Upgrading everyone to Win2000 is
> also not an option.
>
> Does anyone know of a patch or configuration setting that will cause
> this error to go away?
>
> I have never used Oracle outside of ODBC, so I don't know what a bind
> list is. I know that I have seen it in some PL/SQL code listings, but
> that's it. One of these days, I am going to be doing some Oracle Java
> work, so any hints will be helpful in the long run!
>
> Thanks,
>
> Kevin
Received on Tue Jan 15 2002 - 14:22:06 CST