Re: Uploading file

Thanx for replying friedrich
UTL_FILE package is there in 9i .
[Quoted] But my problem is bit diferrent i ve to put those files into OS directory which user has uploaded through web. Files are being uploaded but in database . Now the requirement is to put thoase files in os directory.

friedrich <freedt_at_web.de> wrote in message news:<oprqy4bcltg82rlq_at_news.cis.dfn.de>...
> On 18 Jun 2003 00:12:13 -0700, Upendra Mishra <upendram_at_teri.res.in> wrote:
>
> > Now wht is required i put in steps
> > 1. User is accessing the web appliction.
> > 2. He has to upload a file
> > 3. File should be uploaded in a directory on databse rather than in
> > database as blob column.
> > 4. I ve used PL/SQL and owa package to create web appliaction.
> > How would i be able to achieve this functionality though plsql and owa
> > package or i ve to use some thing else.
> > I am using Oracle 9iAS and Oracle 9i databse.
>
> On 8.1.7 you would need:
>
> 1. to set UTL_FILE_DIR to the directory you want your pl/sql-code to write
> to
> 2. to use the package utl_file and its methods to write the file
>
> I think this wont have changed in 9i.
>
> Friedrich
Received on Fri Jun 20 2003 - 07:10:41 CEST