Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> update clob, long error
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.
--
Jim Poe
<jpoe_at_fulcrumit.com>
Fulcrum InteTech, Inc.
Received on Wed Dec 16 1998 - 16:41:07 CST