node-oracle
node-oracle copied to clipboard
Insert bigger blob or empty blob
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?