Re: uploading external docs on the database.

Everything you need is in the dbms_lob package. You eventually will make a call to DBMS_LOB.LOADFROMFILE. You will need to create an Oracle directory to point to the OS directory where the files are located. Typically you would make the file name be the primary key for the record with an appropriate file extension. If I hadn't changed jobs recently I would have some example code lying around to show you. There are good examples in the docs for the dbms_lob package. Working with lob locators is fairly different from what you're used to with simple numeric and character columns.

Gene Hubert
Durham, NC

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
Received on Thu Aug 09 2001 - 13:22:36 CDT