How to display pl/sql result on browser?
I wrote a simple script to test whether I can view the result ("helloworld") through the browser or not. this is on 220.127.116.11 database with 9iAS 18.104.22.168.2. Am I supposed to make virtual directory somewhere? here is the simple procedure that I used.
create or replace procedure sp_hw2
Have you setup the Database Access Descriptor (DAD) and are you using the correct URL (can you post it)
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
how do you setup DAD? and I don't know the specific path either....
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
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 Oracle Connect string---like "db server nameort:sid"
Click apply. Now you created new dad.
To access the Hello World page(which you created)
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.
Last edited by sree_sri; 07-22-2003 at 03:21 PM.
Click Here to Expand Forum to Full Width