Re: Uploading file

Hello,

I wondered if you could help,

I have a requirement attach documents to a web forms application So users can link to them and open them

I am on (Forms 6i, 9iAS) but my database is only 8.1.6!

I just wondered if you could give me any advice on how I might do this. Any samples you know of or just an oppinion on methodology.

ANY advice is GREATLY appreciated!
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<bcvg6e$ih5$1_at_babylon.agtel.net>...
> "Upendra Mishra" <upendram_at_teri.res.in> wrote in message
> news:214aff7.0306192110.4c3cbda1_at_posting.google.com...
> > Thanx for replying friedrich
> > UTL_FILE package is there in 9i .
> > 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.
> >
>
> Using UTL_BinFile package (available free at our website) you can do
> this pretty easily:
>
> 1. The user uploads the file. It gets saved into a BLOB in the upload
> table by the mod_plsql.
> 2. Your upload handler procedure is invoked and passed the name
> of the file as saved in the NAME column.
> 3. In the upload handler procedure you retrieve the newly arrived
> BLOB by its name and save it to disk using
> UTL_BinFile.Save_BLOB_To_File(blob, filename).
> 4. You delete the row from the upload table and update
> some other table to record the file location so that it can be
> accessed from your web application (if needed.)
> 5. You commit and return some confirmation page or whatever. :)
>
> The package works in 8i and later provided that the JServer/Oracle VM
> is operational (it uses some Java to do the work). Read the docs for
> security-related info and examples (PSP_Mail docs, that is - the package
> is fully documented there.)
>
> Hope this helps.
Received on Mon Jun 23 2003 - 13:30:50 CDT