Making a PSP as startup page

Hi,
I believe I have done this before but now I am not able to recollect it. I have configured a web server which is hosting multiple sites. Beside other entries, the Apachae listener has got following entry. ........
DirectoryIndex index.htm
....... further below I have

<Virtual host 123.123.123.123>

ServerAdmin abc_at_123.com
ServerName host1.com
DocumentRoot D:\host1
</Virtualhost>

<Virtual host 123.123.123.123>

ServerAdmin def_at_123.com
ServerName host2.com
DocumentRoot D:\host2
</Virtualhost>

Now in the D drive I have host1 and host2 folder which contains index.htm which serves as a starting page. Upto here there is no problem but now I want to have a pl/sql PSP page as the startup page for host2. The Database is residing in database server which is physically a different machine. I have configured the Database gateway etc but how can I make that PSP as a home page. Say I have a procedure create or replace procedure hello as
begin
htp.p('Hello and welcome to first page'); end;
/
and I can access this using the configuration say http://host2.com/pls/gateway/hello
but what I need is that when I type
http://host2.com I should automatically get re-directed to the above url. Your help in cracking this nut will be of immense help. Thanking you in anticipation.
Regards

Bhavesh Received on Tue Aug 27 2002 - 04:56:32 CEST