Oracle error ORA-01461when trying to insert into an ORACLE BLOB field

forums_noreply@adobe.com — Wed, 05 Mar 2014 22:32:19 GMT

I am getting Oracle error ‘ORA-01461: can bind a LONG value only for insert into a LONG column' when trying to insert into an ORACLE BLOB field. The error occurs when trying to insert a large BLOB (JPG), but does not occur when inserting a small (<1K) picture BLOB.(JPG). Any ideas?

BTW, when using a SQL Server datasource using the same code.... everything works with no problems.

ORACLE version is 11.2.0.1

The ORACLE datasource is JDBC using Oracle's JDBC driver ojdbc6.jar v11.2.0.1 (I also have tried ojdbc5.jar v11.2.0.1; ojdbc5.jar v11.2.0.4; and ojdbc6.jar v11.2.0.4 with the same error result.)

Here is my code:

INSERT INTO test_images

(

image_blob

)

SELECT

FROM dual

</cfquery>

Adobe Community: Message List - Oracle error ORA-01461when trying to insert into an ORACLE BLOB field

Oracle error ORA-01461when trying to insert into an ORACLE BLOB field