Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » dynamic population of data in a combo box.
dynamic population of data in a combo box. [message #77426] Mon, 31 March 2003 22:15 Go to next message
Messages: 3
Registered: March 2003
Junior Member
I am using oracle PDK technology and writing html pages using PL/SQL procedures.
My problem is to have a dynamic population of data in a combo box.

For example :
I have a combo box(say, Parent) which gets data from DB and display the data for selection.

I have another combo box(say, Child) which also should gets data from DB but, depending upon the above combo box selections.

Like, if we take employee table and Dept table. If parent combo box is the list of dept codes then child combo box should be list of employee names/ids in that particular dept.

Developing Environment

Oracle 9iAS, Oracle 8i(pl/sql)
PDK. Solaris OS.
Re: dynamic population of data in a combo box. [message #77427 is a reply to message #77426] Fri, 11 April 2003 12:03 Go to previous messageGo to next message
Bachir A
Messages: 1
Registered: April 2003
Junior Member
Let's say that your first combobox is CBX_Parent and your second combobox is CBX_Child.

The code to populate your Parent combobox:


v_rg_id_Parent recordgroup;
v_n_Parent number;
Parent_Query Varchar2(1000);


Parent_Query := ' select dname, to_char(dept_no) from dept';

v_rg_id_Parent := create_group_from_query('RG_PARENT', Parent_Query);

v_n_Parent := populate_group('RG_PARENT');


populate_list ('CBX_Parent','RG_PARENT');



The code to populate your Child combobox:


v_rg_id_Child recordgroup;
v_n_Child number;
Child_Query Varchar2(1000);


Child_Query := 'select ename, to_char(empno) from emp where deptno = :CBX_Parent';

v_rg_id_Child := create_group_from_query('RG_CHILD' , Child_Query);

Child_Query := populate_group('RG_CHILD');


populate_list ('CBX_Child', 'RG_CHILD');


I hope that's help you

Bachir A
Re: dynamic population of data in a combo box. [message #77510 is a reply to message #77426] Tue, 09 November 2004 02:23 Go to previous message
Messages: 7
Registered: November 2002
Junior Member
i am trying to add data in combo box ,fetching from database
Previous Topic: information about portal
Next Topic: AS Portal Login
Goto Forum:

Current Time: Wed Jan 27 04:53:25 CST 2021