Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ORA-01026: multiple buffers of size greater than 2000
Message
From
28/04/1999 10:24:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
ORA-01026: multiple buffers of size greater than 2000
Miscellaneous
Thread ID:
00212981
Message ID:
00212981
Views:
85
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
Map
View

Click here to load this message in the networking platform