owa_default_service use
Date: 1997/02/22
Message-ID: <01bc208b$60d13e80$6f121a26_at_sameer>#1/1
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).
How do I get the default service to execute a database procedure ?
A couple of things which I find confusing (and maybe someone can help) :
How does listener find the path of owa executable ? Is path of owa_executable essential in URL ? ie for executing a proc, should the URL be http://machine:port/path_of_owa/service/owa/db_proc ? It looks like that from the documentation but then how does http://machine:8888/owa_dba/owa/test work ? Oracle is doing some mischief here. If you look at sv8888.cfg, owa_dba is logical dir path for $oracle_home/ows/bin and it's also the name of the service. So does this work because of logical path name of service name ? (Note that I tried to do the same for owa_default_service and it still did not work).
Is path for owa executable essential in URL ? If path/service/owa/proc is the std as per manual then I think owa_dba service should be using http://machine:8888/ows-bin/owa_dba/owa/test but this does not work (unknown url).
What I mean by not working is output is same as running owa executable on unix machine at os prompt without any params (ie Request Failed. We are unable to process your request at this time. Please try again later) which makes me think that it's getting to owa and executing it but somehow does not know how to execute database procedure. Why ? Any idea ?
Sameer Utrankar
utrankar_at_pipeline.com Received on Sat Feb 22 1997 - 00:00:00 CET