How to display pl/sql result on browser?

[gaegoori]

I wrote a simple script to test whether I can view the result ("helloworld") through the browser or not. this is on 9.2.0.3 database with 9iAS 1.0.2.2.2. Am I supposed to make virtual directory somewhere? here is the simple procedure that I used.

create or replace procedure sp_hw2
as
begin
htp.htmlOpen;
htp.bodyopen;
htp.p('HelloWorld');
htp.bodyClose;
htp.htmlClose;
end;
/

Thanks.

[jovery]

Have you setup the Database Access Descriptor (DAD) and are you using the correct URL (can you post it)

Regards

[gaegoori]

how do you setup DAD? and I don't know the specific path either....

[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.