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 -> update clob, long error

update clob, long error

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Wed, 16 Dec 1998 14:41:07 -0800
Message-ID: <36783702.737D3D75@fulcrumit.com>


I'm using Delphi 4 with SP2, BDE 5.1, and Oracle 8.0.5 on NT.

I have a CLOB column, named DOC, that gives me this error when trying to update it. 'ORA-01461: can bind a LONG value only for insert into a LONG column'. This error does not occur on all updates. It seems to happen only on records with a larger amount of data in the column. It also occurs in two identical databases with the exception that one database uses a LONG column and the other database uses a CLOB column.

I've traced the update using SQL monitor. The following shows the first line that is different in the two traces.

  1. No error - 14:05:54 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'FIT_DBA' and object_name = 'STANDARD' order by 1 ASC, 2 ASC
  2. With error - 14:13:12 SQL Prepare: ORACLE - update "FIT_DBA"."STANDARD" set
    "DOC" = :1
    where
    "KEY_ID" = :2 and
    "TYPE_CD" = :3 and
    "PARENT_ID" = :4 and
    "DSCR" = :5
Any ideas?

--
Jim Poe
<jpoe_at_fulcrumit.com>
Fulcrum InteTech, Inc. Received on Wed Dec 16 1998 - 16:41:07 CST

Original text of this message

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