Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01026 error
I'm using Oracle 8.1.5
ORA-01026 multiple buffers of size > 4000 in the bind list
Cause: More than one long buffer in the bind list.
Action: Change the buffer size to be less than 4000 for the bind variable bound to a normal column.
I'm not sure what I should be doing here. I have a table that contains two CLOB and one BLOB column. The documentation indicates that more than one LOB per table is supported. How do I update two or more columns that are larger than 4k?
I'm currently using this SQL:
insert into VCS (
VERSION_COMMENTS,
FILE_CONTENTS,
DFM_CONTENTS,
PROJECT,
FILENAME,
MAJORVERSION,
MINORVERSION,
MAJORBRANCH,
MINORBRANCH,
VERSION_TS,
VERSION_AUTHOR,
RELEASE, LABEL,
FILE_CREATION_DT,
RELATIVE_PATH )
VALUES
(EMPTY_CLOB(), EMPTY_CLOB(), EMPTY_BLOB(),