You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I insert a pdf file into blob column in OIC?

in Integration 3 comments

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!