Oracle DB: BLOB issue

[ssah]

Dear everybody,

I am using an external Oracle DB, and a connection from WinCCOA via DSN with ODBC.
The problem I am having is writing to a BLOB field.

A temporary solution works with CLOB instead. The essence of the code I'm using:

Code: Select all

string ITEM = "SomeLongString"
rc = dbOpenConnection ("DSN=Oracle;UID=oracle;PWD=oracle;", conn);
rc = dbOpenRecordset (conn, "SELECT * FROM ... WHERE ...", rs, 1);
rc = dbPutField (rs, CLOB_FIELD, ITEM);
rc = dbUpdate (rs);
dbCloseRecordset (rs);
dbCloseConnection (conn);

Regardless of what type I use, writing to a BLOB field results either in invalid type error, or the operation succeeds but the content of the field is left empty.
Did anybody came across a similar problem or does anybody have a suggestion on how to resolve this issue?

Best Regards,
SSah