Re: Connecting to PL/SQL procedure from Web Agent

kolya_at_lo-risk.stanford.edu wrote:

> Anyone who can, please help me!
>
> The Problem:
>
> Can't start up a PL/SQL procedure through Oracle Web Agent
> I have installed an Oracle Web Server.
>
> I made a Web Page with a Form which is supposed to pass on
> information
> to the PL/SQL procedure as parameters.
>
> The action of the form points to the following URL:
>
> <MyComputer><MyORACLE_HOME>/ows-bin/owa/<ProcedureName>
>
> .......

> Question 1:
> What should I do to make the Web Agent start up my PL/SQL
> procedure?
>
> Question 2:
> Is there anyway I can get an explaination of the format of a
> Web
> Listener Log file. When I open the log file I see that the form
> DID
> send a message to the Web Agent. That line in the log file
> is followed
> by two numbers which I think may be error messages. If so does anyone
> know what "404 99" stand for?

What you need to do is map ORACLE_HOME/ows20/bin/ to /[pl/sql agent name]/owa/ , i.e. if your agent name is web01, and your oracle home is o:\orant, and you're running web server 2.0, then map O:\ORANT\OWS20\BIN\ to /web01/owa/ on the listener admin page.

Then, on the Web Request Broker page, make sure that under "Applications and Objects", OWA is correctly mapped to O:\ORANT\OWS20\BIN\OWA.DLL, and under "Applications and Directories", have virtual path = /web01/owa, App. = OWA, and physical path = O:\ORANT\OWS20\BIN.

Remember that this all assumes that web01 is the Agent and o:\orant\ows20 is where the web server is installed. Just check these two things and you should be good to go.

--
Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com