Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01026: multiple buffers of size greater than 2000 in the bind list
I get the following message peruiodically in my application.
ORA-01026: multiple buffers of size greater than 2000 in the bind list
Cause: There is more than one long buffer in the bind list.
Action: Change the buffer size to be less than 255 for the bind variable bound to a normal column.
However, I don't understand what it is I should do to fix this this.
Can someone explain this.
The program done in VFP 6.0
There is one area in particular where I get it:
Here is the SQL: UPDATE "PREFS" SET
"USERNO"=?var1,"OPLIST_SK"=?var2,"SPEC_SK"=?var3,"MEAS_ML"=?var4,"SHOWPICT"=?
var
5,"REFRESHOM"=?var6,"USEPRTSERV"=?var7,"SORTORDER"=?var8,"SEEK"=?PREFS.SEEK,"
FIL
TER"=?PREFS.FILTER,"FILTERSET"=?var9,"ARTIVIEWOT"=?var10,"PLMODULES"=?PREFS.P
LMO
DULES,"SPECLIST"=?PREFS.SPECLIST,"MEASLIST"=?PREFS.MEASLIST,"COLRLIST"=?PREFS
.CO
LRLIST,"COLPLIST"=?PREFS.COLPLIST,"STITLIST"=?PREFS.STITLIST,"ARCOLIST"=?PREF
S.A
RCOLIST,"UNITLIST"=?PREFS.UNITLIST,"CURRLIST"=?PREFS.CURRLIST,"SUPPLIST"=?PRE
FS.
SUPPLIST,"INTCLIST"=?PREFS.INTCLIST,"PLANLIST"=?PREFS.PLANLIST,"SAMPLIST"=?PR
EFS
.SAMPLIST,"COMPLIST"=?PREFS.COMPLIST,"CUSTLIST"=?PREFS.CUSTLIST,"SEASLIST"=?P
REF
S.SEASLIST,"QUALLIST"=?PREFS.QUALLIST,"KNCOLIST"=?PREFS.KNCOLIST,"INSTLIST"=?
PRE
FS.INSTLIST,"SPCMLIST"=?PREFS.SPCMLIST,"MARKLIST"=?PREFS.MARKLIST,"OPLILIST"=
?PR
EFS.OPLILIST,"LOSPLIST"=?PREFS.LOSPLIST,"ASRTLIST"=?PREFS.ASRTLIST,"ATCHLIST"
=?P
REFS.ATCHLIST,"DESSLIST"=?PREFS.DESSLIST,"SPPALIST"=?PREFS.SPPALIST,"COSILIST
"=?
PREFS.COSILIST,"LDATE"=SYSDATE,"LTIME"=?var11,"LASTEDIT1"=?var12,"LASTEDIT2"=
?va r13,"ARTIORDER"=?var14 WHERE recno = 21
I apolagize for the unreadablity of the statement and appreciate all and any help.
If you respond cc my email
Thanks
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 09:27:15 CDT
![]() |
![]() |