General information
Title:
ORA-01026: multiple buffers of size greater than 2000
I get the following message periodically 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"=?var5,"REFRESHOM"=?var6,"USEPRTSERV"=?var7,"SORTORDER"=?var8,"SEEK"=?PREFS.SEEK,"FILTER"=?PREFS.FILTER,"FILTERSET"=?var9,"ARTIVIEWOT"=?var10,"PLMODULES"=?PREFS.PLMODULES,"SPECLIST"=?PREFS.SPECLIST,"MEASLIST"=?PREFS.MEASLIST,"COLRLIST"=?PREFS.COLRLIST,"COLPLIST"=?PREFS.COLPLIST,"STITLIST"=?PREFS.STITLIST,"ARCOLIST"=?PREFS.ARCOLIST,"UNITLIST"=?PREFS.UNITLIST,"CURRLIST"=?PREFS.CURRLIST,"SUPPLIST"=?PREFS.SUPPLIST,"INTCLIST"=?PREFS.INTCLIST,"PLANLIST"=?PREFS.PLANLIST,"SAMPLIST"=?PREFS.SAMPLIST,"COMPLIST"=?PREFS.COMPLIST,"CUSTLIST"=?PREFS.CUSTLIST,"SEASLIST"=?PREFS.SEASLIST,"QUALLIST"=?PREFS.QUALLIST,"KNCOLIST"=?PREFS.KNCOLIST,"INSTLIST"=?PREFS.INSTLIST,"SPCMLIST"=?PREFS.SPCMLIST,"MARKLIST"=?PREFS.MARKLIST,"OPLILIST"=?PREFS.OPLILIST,"LOSPLIST"=?PREFS.LOSPLIST,"ASRTLIST"=?PREFS.ASRTLIST,"ATCHLIST"=?PREFS.ATCHLIST,"DESSLIST"=?PREFS.DESSLIST,"SPPALIST"=?PREFS.SPPALIST,"COSILIST"=?PREFS.COSILIST,"LDATE"=SYSDATE,"LTIME"=?var11,"LASTEDIT1"=?var12,"LASTEDIT2"=?var13,"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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only