Re: Uploading file

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 Wed Jun 18 2003 - 12:31:50 CDT