Re: Error in Oracle web server file upload

Under which db user name did you compile the procedure? If you did it under any name other than that used by the Web Server and didn't grant subsequent execution rights to the web server user, you would get the 'Request Failed' error. The error usually indicates that the package/procedure/function being called either:

1. doesn't exist
2. isn't owned/executable by the web server's db user, or
3. you are passing a parameter to the procedure that it doesn't expect to receive.

The last scenario above would occur if you are calling the procedure by clicking a button on a web page that's performing a submit/post to the new procedure, and the new procedure does not have that button's HTML name set up as an 'IN' parameter of type varchar2.

Try editing the source for the new procedure by adding the calling HTML form button as a varchar2 IN parameter, then recompiling through SQL*Plus after logging into the db with the same userID your web server uses.

Hope this helps,
-Brendan

In article <6jli0v$klb$1_at_hisgw.hitachi-his.co.jp>,   shun_at_head.hitachi-his.co.jp (Shun Abe) wrote:
>
> Hi,
>
> I have a problem with the file upload utility which I downloaded from
> http://govt.us.oracle.com .
> Whenever the procedure "imgload.do_it" was called, I get a message like
> this in the web brouser;
> -----------------------------------------------------
> Request Failed
> -----------------------------------------------------
> We were unable to process your request at this time.
>
> Please try again later.
> -----------------------------------------------------
>
> I use Oracle 7.3.3 / Oracle Web Server 3.0 / HP-UX 10.20.
>
> Any hints/suggestions ?
>
> Thanks in advance.
> --
> Shun Abe <shun_at_head.hitachi-his.co.jp>
> Hitachi Information Systems,
> Tokyo
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 00:00:00 CDT