I'm trying to get my program to execute the following SQL statement:
SQL_STRING = "update MYTABLE SET COLUMN1=:val1, COLUMN2=:val2 where COLUMN3=:val3"
where COLUMN1 is a BLOB datatype and COLUMN2 is a NUMBER datatype.
I'm using OCCI interface.
blob.write(size, buffer, size);
Statement stmt = connection->createStatement(SQL_STRING);
I am getting SQLException with Oracle message:
Error ORA-22275: invalid LOB locator specified
What's the right way to insert new (updated) BLOB object into the existing row?
Links to a good OCCI tutorial or example code are also appreciated.