How can I insert a pdf file into blob column in OIC?
Summary:
How can I insert a pdf file into blob column in OIC?
I have a pdf file that transfers into /stage with the ftp adapter and I need it insert it into a blob column in a Oracle database table.
I tried using stage file action to list the file and mapped the file reference from this list to insert into the blob column using OIC
Oracle database adapter but get an error below:
DBWriteInteractionSpec Execute Failed Exception. insert failed. Descriptor name
Description: The object [xs:base64Binary fss: xxxxx of class [class java.lang.String],
could not be converted to [class [B]. Internal Exception: com.sun.mail.util.DecodingException: BASE64Decoder: Error in encoded stream: needed at least 2 valid base64 characters,