on 05-27-2015 3:25 PM
Hello,
I have a scenario where I need to read a PDF file and insert in to a BLOB field. There is already an existing graphical map to update columns through a stored procedure and this Blob column is a new addition. Can I write a UDF to read the binary file and convert it to binary hex to send it to the JDBC adapter. The PDF filename is based on a value from the source structure. Can any one outline how would I read a file in the UDF and convert it to Binary hex?
Thank you.
Larry.
Resolved with a UDF to read the PDF from the attachment and load it to the blob column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Harish,
I checked that blog, that was helpful. I need to know how to efficiently read the PDF file in the UDF without the file adapter?
Please advise.
Larry.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.