Dynamic webpage generation using PL/SQL

[aakhil]

Hi

We have an application running on Sun OS 2.6 and uses Oracle 7.3.4 database and Oracle Web Application server. The application basically uses PL/SQL packages , Proc files and CGI perl scripts.

The PL/SQL procedures dynamically generate HTML pages using the HTP and HTF packages of the Oracle Web Server.

One of the dynamically generated HTML page has two drop down list boxes. We are required to code such that depending on certain choices in one of the drop down list box, the default value for the other drop down list automatically changes. We felt that we could use java script to do the same.

Will we be able to use java script for this kind of dynamic HTML page generation using the HTP and HTF packages of OWAS. Please advise us on the same.

[eugene]

you can do this only if you know the values in advance and willing to hard code them into javascript (unless you want to write a java applet that actually queries the database)
otherwise use PLSQL
once the chioce is made in one of the drop downs,
POST and generate the other drop down list

Eugene Roytman
OCP

[sree_sri]

Yeap!

When One Drop down box value changed and if you want to change other drop down box values then you have to retrieve data from the database.

For example you have to drop down boxes called
country_names and another one is state_names.

When you first display page, You will select one default country name and you fill the second drop down box with associated state names.

To do this, You need some type of program or URL. (I hope, for that program you will send the default country name as parameter)

The same method you will use when user select different country name.

You will put that code in javascript and associate with first drop down box.(onchange="javascript:selectcountry();"

in selectcountry function(javascript), The default page program you will call it, But instead of sending default country name, you will use the user selected country name.

I developed this type of page in PSP(Plsql server pages). If you need more help then let me know. Good Luck.