Re: owa_default_service setup

Sameer Utrankar wrote:
>
> This is a new ows setup. I have 2 services : owa_dba at port 8888 and
> owa_default_service at port 80. I am trying to write a simple test
> procedure (doing nothing but htp.print('hi')). I can run the procedure
> as
> http://machine:8888/owa_dba/owa/test and it works fine. However I cannot
> get this to work with owa_default_service. ie I cannot run
> http://machine:80/owa/test or
> http://machine:80/ows-bin/owa/test (where ows-bin is set to path of owa
> executable in sv80.cfg) or
> http://machine:80/owa_default_service/owa/test (where
> owa_default_service is set to path of owa executable in sv80.cfg and is
> also the name of the default service).

Hi Sameer,

You are confused about the way OWS handles the URLs with "owa". What happens is that with such a URL, the OWS listener will interprete the preceding word as the DCD service.
A DCD service defines how the OWS listener makes a database connection to execute procedures, etc. It is defined in your OWS admin home page.

eg. "http://www.foo.com/apple/owa/test" will be interpreted as a path to use the DCD "apple" to connect to the database to execute the procedure "test".

To make things simple, just think of path names with "owa" as logical paths used by the OWS listener to connect to the database. It does does not correspond to any physical directories or executables on you server.

If your procedure does not work using a particular DCD, my advice is to check your DCD to see which userid is used to connect to the database. Compile your procedure using the userid defined in the DCD and things should work. If it still fails, check your logs in $ORACLE_HOME/ows20/log

Good luck and let me know if you still need help.

rgds,
mars Received on Tue Feb 25 1997 - 00:00:00 CST