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>

SQLITE data acess from a library

forums_noreply@adobe.com — Mon, 13 Dec 2010 04:03:25 GMT

I am starting to look at developing a desktop and a handheld project that requires the same sqlite code. The model/view/controller method suggests that all database code should go into a library that can be shared between the two projects. Problem is, it seems I can't use any classes that involve flash.data in a library. For example, I went to use the following code in my library:

...
import flash.data.SQLConnection;
...
public function SQLStatementFactory(aConn:SQLConnection) {

and it gives me an error: 1046: Type was not found or is not a compile-time constant: SQLConnection

The code works if it is not in a library project. If you can't use data access in libraries, how am I supposed to isolate the controller code? Has anyone run across this problem before?

Adobe Community : All Content - All Communities

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

SQLITE data acess from a library