asked on

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.

Sean Stuber

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.

mjfigur

ASKER

Ok great thanks what would I need to do to store it in a BLOB?

SOLUTION

GlobaLevel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sean Stuber

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

mjfigur

ASKER

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

mjfigur

ASKER

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?

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mjfigur

ASKER

Thanks everyone for your help this was a major assistance.