Re: insertion of PDF files in to Oracle 8

From: Alan Barker <Ajb1_at_nextcentury.com.au>
Date: 2000/07/15
Message-ID: <89Tb5.185$l3.496@news.syd.ip.net.au>#1/1

Obviously , it may be necessary to use a clob, but have you considered using bfiles and storing the pdfs in the OS. Then you can create directories in the db to link to your files.

Regards,
Alan Barker
Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid> wrote in message news:11d2e53d.360fe1a3_at_usw-ex0102-015.remarq.com...
> msundar1977_at_my-deja.com wrote:
> >i am writing a cgi/perl program. could anyone
> >please let me know how to insert a PDF file in
> >to the database with corresponding data type
> >defined to be "CLOB" (oracle 8).
> >
> I have never done what you are planning, but I believe the place
> to start is to look at the dbms_lob package since it provides
> the functionality necessary to create, update, and read LOB's.
>
> Also since a PDF file contains non-printable characters I think
> you should be using a BLOB instead of a CLOB to hold the
> document.
>
> Good Luck.
>
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Sat Jul 15 2000 - 00:00:00 CDT