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

From: Gambito <gambito_at_noalspam.cl>
Date: Fri, 18 Feb 2005 17:35:36 -0300
Message-ID: <cv5jii$a0k$1@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! Received on Fri Feb 18 2005 - 14:35:36 CST