Newsgroups: comp.databases.oracle.misc Subject: Upload Problem on OAS From: santeel Message-ID: User-Agent: Xnews/L5 NNTP-Posting-Host: news1 Date: 8 Apr 2002 11:58:57 -0700 Lines: 80 Path: news.easynews.com!easynews!hub1.nntpserver.com!telocity-west!TELOCITY!news1!newsfeed.directvinternet.com Xref: easynews comp.databases.oracle.misc:79870 X-Received-Date: Mon, 08 Apr 2002 11:56:45 MST (news.easynews.com) Oracle Ver: 8.1.6 OAS Ver: 4.0.8.6 OS Ver: Win NT 4.0 I am trying to upload a file to the server using the PL/SQL Toolkit. The toolkit is installed. I followed the directions in the PL/SQL Toolkit PDF documentation. What is supposed to happen is that the file is uploaded and the filename is passed as a paramater of the procedure. What is happening is that the contents of the uploaded file are being placed in the parameter that is supposed to be the filename. Below are the form, procedure and results. -----------------------------------html form------------------------------ File Uploader

File Uploader

Label:
Attachment to upload:
---------------------------------------procedure----------------------- PROCEDURE save_file(filedoc IN INTEGER, usrt IN VARCHAR2 := 'escrow1', filename IN varchar2, myfile IN varchar2) AS docLob clob; lobLength number := 255; lobOffset number := 1; textBuffer VARCHAR2(255); loblen number; thecount number; BEGIN wl('Stand alone procedure
'); wl(filedoc || '
'); wl(usrt || '
'); wl(filename || '
'); htp.print(myfile); END; --------------------------------------results of uploading a file c:\me.jpg and Label = test------------------ Stand alone procedure
0
I
test
ÿØÿà