node-oracle icon indicating copy to clipboard operation
node-oracle copied to clipboard

Insert bigger blob or empty blob

Open ionutliviu opened this issue 10 years ago • 0 comments

I've tried inserting an empty_blob INSERT INTO files (content) VALUES (empty_blob()) and I got the following error:

libc++abi.dylib: terminating with uncaught exception of type oracle::occi::SQLException: ORA-32109: invalid column or parameter position

Inserting a 3KB file INSERT INTO files (content) VALUES (to_blob(:1)) will return this error:

Error executing query: [Error: ORA-01461: can bind a LONG value only for insert into a LONG column

Is there a way to insert even bigger files?

ionutliviu avatar Jan 15 '15 22:01 ionutliviu