Re: uploading external docs on the database.

I'm unclear what it is you are trying to achieve?

If you are trying to store word and excel data etc in an oracle database then it is perfectly possible to store these documents in a BLOB field. Basically what you would do would be to find the length of the file and then append the data in in chuncks.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**
"Jitesh Chheda" <jiteshpc_at_hotmail.com> wrote in message
news:3B70986D.D6850141_at_hotmail.com...


> Hi,

>

> I would like to upload external documents like Word, Excel to an oracle

> document using PL/SQL. Is it possible.

> Can some one provide a sample code to upload such text documents.

>

> Checked up a OTN but it does talk of Video and Audio files only. Would

> like to know if non-binary files like *.doc, *.xls can be uploaded and

> read from the DB.

>

> Any help in this matter would be appreciated.

>

> Thanks in Advance

>

> Jitesh

>