Re: OAS 4.0 Content Service & Uploading problem

There are sample codes in OAS that deals with file uploading/downloading.

Vladimir Vuksan wrote:

> Has anyone succeeded in getting Content Service running under OAS 4.0 ?
> I would like to upload files and then insert them into the table. I have
> succeeded in uploading text only files using the directions in
> apps4.0.pdf document that is available at Technet but can't figure out
> how to upload binary files. The documentation is really sketchy. For
> instance I tried something like this
>
> procedure write_info (
> who in varchar2,
> description in varchar2,
> userfile in blob) as
> ^^^^^^^^^^^^^^^^
> begin
> insert into myTable values (who, description, userfile);
> htp.htmlopen;
> htp.headopen;
> htp.title('File Uploaded');
> htp.headclose;
> htp.bodyopen;
> htp.header(1, 'Upload Status');
> htp.bodyclose;
> htp.htmlclose;
> end;
>
> It reports an error. If I change userfile to varchar2 it works fine :-(.
>
> Any clues ?
>
> Vladimir
Received on Tue Jun 01 1999 - 23:34:05 CDT