Re: How to upload a file using web and pl/sql?

From: Ronald Rood <devnull_at_ronr.nl>
Date: Sat, 19 Feb 2005 08:58:12 +0100
Message-ID: <0001HW.BE3CB02400C79654F02845B0@news.individual.net>

On Fri, 18 Feb 2005 21:35:36 +0100, Gambito wrote (in article <cv5jii$a0k$1_at_helcaraxe.dcc.uchile.cl>):

> Hi:
>
> Does anyone have an example of how to upload a file using a web form and
> pl/sql? I'm trying to find some information but i can't found what i
> want. If you have the following form:
>
> <form name=frm1 action=pck_doc.upload_file method=post
> ENCTYPE="multipart/form-data">
> <input type=file name=p_file length=20>
>
>
> how should be the parameter for the procedure?
>
> For example
>
>
> CREATE OR REPLACE PACKAGE BODY PCK_DOC IS
> ...
>
> PROCEDURE UPLOAD_FILE (P_FILE BLOB) IS ...
>
>
> is that correct? p_file should be blob? and after that, how do i upload
> that file to database?
>
> Any ideas?
> Thanks!

Look at the howto's in htmldb <http://htmldb.oracle.com/otn> Might be what you want.

With kind regards / met vriendelijke groeten, Ronald

http://ronr.nl/unix-dba
http://homepage.mac.com/ik_zelf/oracle Received on Sat Feb 19 2005 - 01:58:12 CST