cancel
Showing results for 
Search instead for 
Did you mean: 

UDF for PDF in to a BLOB JDBC

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Resolved with a UDF to read the PDF from the attachment and load it to the blob column.

Former Member
0 Kudos

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.

Harish
Active Contributor
0 Kudos

Hi Larry,

Please check the below blog

regards,

Harish