Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to read a PDF from within PL/SQL?

user12240205Mar 14 2012 — edited Mar 26 2012
we have a requirement like this: We have a Time Tracking and Project Monitoring System whose DB is a Oracle 10g R2. We want to automate our ''Meeting Minute'' processing.

-- The project lead will write minutes into a form PDF.
-- I.e. a PDF where people can type in information to fields.
-- The PDF will be e-mailed to the project manager.
-- Project manager will save the PDF in a HDD directory.
-- Then he will run a program.
-- Program will pickup all the PDFs in directory one-by-one.
-- For each PDF, the program should read the fields.
-- Read values will be inserted to the DB.

Now, my problem is, HOW ON EARTH TO READ A "PDF"???

One option is to CONVERT the PDF to XML and then read the XML. BUT, unfortunately after googling for over 4 hours I came up empty on converting PDF to XML.

How can we do this???

Any help would be greatly appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2012
Added on Mar 14 2012
6 comments
1,618 views