Re: Uploading file
From: friedrich <freedt_at_web.de>
Date: Wed, 18 Jun 2003 19:31:50 +0200
Message-ID: <oprqy4bcltg82rlq_at_news.cis.dfn.de>
Date: Wed, 18 Jun 2003 19:31:50 +0200
Message-ID: <oprqy4bcltg82rlq_at_news.cis.dfn.de>
[Quoted] 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:
- to set UTL_FILE_DIR to the directory you want your pl/sql-code to write to
- to use the package utl_file and its methods to write the file
I think this wont have changed in 9i.
Friedrich Received on Wed Jun 18 2003 - 19:31:50 CEST