Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01026: multiple buffers of size greater than 2000 in the bind list

ORA-01026: multiple buffers of size greater than 2000 in the bind list

From: <tim.mcconechy_at_runtime.dk>
Date: Wed, 28 Apr 1999 14:27:15 GMT
Message-ID: <7g75rt$58h$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US