Very Computer

Hi,

I need to be able to read a file from a client PC
into a PL/SQL procedure via an HTML format.  I
have tried using:-
<FORM
enctype="multipart/form-data"
action="try_files.write_info"
method="POST">
<p>File to upload:
<INPUT type="file" name="file"><br>
but, although the webserver picks up the file, I
do not know how to configure the PL/SQL procedure
to accept the contents (I currently use
VARCHAR2s, but the webserver log states that no
procedure matches the arguments)

HELP!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Hi,

I need to be able to read a file from a client PC
into a PL/SQL procedure via an HTML format.  I
have tried using enctype="multipart/form-data" in
the FORM tag and type="file" for the input tag
but, although the webserver picks up the file, I
do not know how to configure the PL/SQL procedure
to accept the contents (I currently use
VARCHAR2s, but the webserver log states that no
procedure matches the arguments)

HELP!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

(if that email address didn't require changing)

the plsql cartridge with oas3.x does not support file upload.  the plsql
cartridge with oas4.x does.

in the meanwhile, if you have a c compiler, you can use the OWA replacement
cartridge found at http://govt.us.oracle.com/~tkyte/ .  It does support file
upload.  OAS3.x install directions in the file owarepl/doc/oas3.html

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...
Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th

Oracle Service Industries     Reston, VA   USA
--
Opinions are mine and do not necessarily reflect those of Oracle Corporation