In BPM we cannot insert/update blob column directly. We have 2 services in System Data toolkit.
One is “SQL Blob to File” and the other is “SQL File to Blob”.
First we need to select the record without BLOB column and insert it to the target table.
After that we select the BLOB column only with BPM integration below.
Sql statement: select NVL(DATA,EMPTY_BLOB()) DATA from LSW_BPD_INSTANCE_DATA WHERE BPD_INSTANCE_ID = ?
This service is selecting the BLOB column and writing BLOB data as a file in WAS.
After that we update my target column with this BLOB data.
Sql statement: UPDATE ARCHIVE.ARCH_LSW_BPD_INSTANCE_DATA SET DATA = ? WHERE BPD_INSTANCE_ID = ?