Store embedded object into oracle database

HCL Domino Domino Forum
1

Hi All,

I want to store the embedded object (File attachment)into oracle database in BLOB datatype of oracle column.

I have successfully done the connection, only thing is that error is generating while converting the embedded object into BLOB type.

here is my code:

EmbeddedObject object = doc.getAttachment(value);

BLOB obj=(BLOB)object; // error in this line

boolean a=st.execute(“insert into abc.TEST (ID,attachment)values(”+doc.getItemValueString(“docId”)+“,”+ obj +“)”);

any reply would be appreciable…

With Regards

Zubair A Khan