How to display pl/sql result on browser?

[sree_sri]

I hope you installed 9iAS web server correctly,

Type your server name in browser like http://server_name:"port_no"/
If 9iAS web server installed correctly then it will show default index page .

In that page you will see Apache docemenation and other links. Search for "Mod plsql Configuration Menu" link in that page. If you find one then, Click on that link. It will take to you

http://server_name:"port_no"/pls/default_dad/admin_/gateway.htm
In that page you will see

Gateway Global settings and
Gateway Database Access Description setting.

Click on the Gateway Database Access Description setting and
click on add default.

Enter Database Access Description Name---like "test_dad"
You can leave Schema Name
Enter Oracle user Name---
Enter Password----
Enter Oracle Connect string---like "db server nameort:sid"

Click apply. Now you created new dad.

To access the Hello World page(which you created)

http://server_name:"port_no"/pls/test_dad/sp_hw2

This above link will connect to the database and execute the sp_hw2 procedure and it will display "HelloWorld" message in html page.

This is basic, You can read more in metalink regarding how to setup DAD,How to write PSP and How to set up other parameters and How to setup security for DAD...all the stuff.

Good Luck.

Sree.