Hello,
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 blob(pConn);
blob.write(size, buffer, size);
Statement stmt = connection->createStatement(SQL_STRING);
stmt.setBlob(1, blob);
stmt.setNumber(2, value2);
stmt.setString(3, 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.
] 
Blog
Search
Help
Members
Register
Login
Home
