DAD user should have insert and select privileges on WEBSYS.OWS_CONTENT,
and OWS_CONTENT synonym pointing to the table,
or you should create similar table in that user's schema (using the same DDL).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Dan Kefford" <dan_kefford_at_hotmail.com> wrote in message
news:13f8fcb0.0204241027.4c03a8ec_at_posting.google.com...
> Greetings all...
>
> I am not able to upload files into the database based on part of the
> example given in the MetaLink site, note #77573.1.
>
> Here are the versions of software being used:
>
> Oracle8i EE 8.1.6.3
> OAS 4.0.8.2.3
> AIX 4.3.3
>
>
> Here is the my source:
>
> CREATE OR REPLACE PACKAGE websys.foobar IS
> PROCEDURE upload_form ;
> PROCEDURE upload_data(file_name IN VARCHAR2) ;
> END foobar ;
> /
>
> CREATE OR REPLACE PACKAGE BODY websys.foobar AS
> PROCEDURE upload_form IS
> BEGIN
> htp.hr;
> htp.header(1, 'File Uploading');
> htp.hr;
> htp.formopen(CURL=>'foobar.upload_data',
> CMETHOD=>'POST',
> CENCTYPE=>'multipart/form-data');
> htp.tableopen(CBORDER=>'0');
> htp.tablerowopen;
> htp.tabledata('File:');
> htp.tabledata('<INPUT TYPE="FILE" NAME="file_name">');
> htp.tablerowclose;
> htp.tablerowopen;
> htp.tabledata(htf.formsubmit);
> htp.tabledata(htf.formreset);
> htp.tablerowclose;
> htp.tableclose;
> htp.formclose;
> END upload_form ;
>
> PROCEDURE upload_data(file_name IN VARCHAR2) IS
> BEGIN
> htp.htmlopen;
> htp.headopen;
> htp.title('File Uploaded');
> htp.headclose;
> htp.bodyopen;
> htp.header(1, 'Upload Status');
> htp.print('Uploaded successfully');
> htp.bodyclose;
> htp.htmlclose;
> END upload_data ;
> END foobar;
>
> I created these objects under WEBSYS, created a public synonym, and
> made sure our DAD user has execute on the package.
>
> When I attempt to upload a file into the database, the result is
> simply the 'Uploaded successfully' message, but no record in
> WEBSYS.OWS_CONTENT.
>
> Am I missing something? I thought this was going to be a no-brainer
> but this has been frustrating me for a full day now.
>
> Thanks in advance,
>
> dan
Received on Sat Apr 27 2002 - 09:51:36 CDT
