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 error

ORA-01026 error

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Tue, 18 Jan 2000 01:24:55 GMT
Message-ID: <3883C0F8.2EB0B80F@fulcrumit.com>


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(), 

:FILENAME,
:PROJECT,
:MAJOR_VERSION,
:MINOR_VERSION,
:MAJOR_BRANCH,
:MINOR_BRANCH,
:VERSION_TS,
:VERSION_AUTHOR,
:RELEASE, LABEL,
:FILE_CREATION_DT,
:RELATIVE_PATH )

   RETURNING VERSION_COMMENTS INTO :VERSION_COMMENTS    RETURNING FILE_CONTENTS INTO :FILE_CONTENTS    RETURNING DFM_CONTENTS INTO :DFM_CONTENTS --
Jim Poe
<jpoe_at_fulcrumit.com>
Fulcrum InteTech, Inc. Received on Mon Jan 17 2000 - 19:24:55 CST

Original text of this message

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