Oracle CLOB and Store entire PDF in Table

All,

I am new to working with Oracle Text and CLOBs, but I have read much of the Oracle documentation regarding Oracle Text but just have one issue I cannot get my head around. Currently I use Toad 10.6 and Oracle 11g R1.

I have a single PDF file that I would like to upload and store in a table. After that I would like for Oracle Text to index the contents of the file. I understand the index portion but I cannot seem to figure out how to upload that entire PDF and store it into the table.

Thanks in advance for your help.
mjfigurAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
A PDF would be stored in a BLOB,  rather than a CLOB.

If you extracted all the text you could store that in a CLOB though.
mjfigurAuthor Commented:
Ok great thanks what would I need to do to store it in a BLOB?
GlobaLevelProgrammerCommented:
why would you want to store the .pdf in a database?

if you use it again on the interent you will have to reformat again....I am assuming your are using for internet usage...store in a web server....then store the the file path in the database...that way download to client will be much faster...
Need More Insight Into What’s Killing Your Network

Flow data analysis from SolarWinds NetFlow Traffic Analyzer (NTA), along with Network Performance Monitor (NPM), can give you deeper visibility into your network’s traffic.

sdstuberCommented:
using Toad you can browse your table in the schema browser, double click on the blob column and it will bring up a window with an option to load a file into the blob contents.

I don't know that Oracle Text will work with the blob contents though, but that's not my strongest area.  I'll let other experts chime in on that particular aspect of your question
mjfigurAuthor Commented:
Thank you for you help that makes sense to store it on a web server so that it can be referenced at a later time and just store the URL. I have a meeting today about the search requirements so will update with additional questions I am sure
mjfigurAuthor Commented:
Actually just thought of another question. Rather than upload the entire file if I just extract the text and place it into a CLOB what is the best way to extract a PDF but attempt to keep the formatting? XML? HTML? and how would you go about doing that?
sdstuberCommented:
if you extract the text you can't regenerate the original pdf with formatting,  you could possibly create a new one though there are pl/sql packages for creating pdf files.  The results may or may not look like the original.  If the original has an embedded charts, images or other non-text content it will be lost.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mjfigurAuthor Commented:
Thanks everyone for your help this was a major assistance.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.