Skip to Main Content
  • Questions
  • Insert Text as header footer PDF BLOB

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Fareed.

Asked: March 18, 2017 - 1:34 am UTC

Last updated: March 18, 2017 - 5:31 am UTC

Version: Oracle 12c

Viewed 1000+ times

You Asked

Hi,

I have a business requirement to stamp every PDF which is stored as blob in Oracle 12c with a vendor name as header and footer.

We should be able to pass the vendor name as argument to the PDF and it will be placed into the header and footer.

PDF can be multiple pages.

Please help.

Thanks
Fareed

and Connor said...

You will need some sort of software that lets you manipulate PDF's. As a blob in the database, we simply see it as binary data - to us, it could be a PDF, audio, video, a picture etc.

You could do this outside the database and save the PDF back once edited, or you could explore if there are utilities in Java, and look at loading them into the JVM within the database to do the job.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here