Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ORA-01026: multiple buffers of size greater than 2000
Message
De
28/04/1999 10:24:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
ORA-01026: multiple buffers of size greater than 2000
Divers
Thread ID:
00212981
Message ID:
00212981
Vues:
84
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
Répondre
Fil
Voir

Click here to load this message in the networking platform