Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DYNAMIC LIST ITEM THROUGH RECORD GROUP

229518Jun 8 2005 — edited Jun 9 2005
Hi,

I want to display a multiple dynamic list items through Record Groups.

CODE OF RECORD GROUP:
PROCEDURE pop_list(p_litem in varchar2,p_query in varchar2) IS
rg_name constant varchar2(30):=get_item_property(p_litem, item_name);
rg_id recordgroup;
BEGIN
rg_id:=find_group(rg_name);
if id_null(rg_id) then
rg_id:=create_group_from_query(rg_name,p_query);
end if;
if populate_group(rg_id)=0 then
populate_list(p_litem, rg_id);
copy(get_list_element_value(p_litem,1),p_litem);
end if;
END;

CALLING AT WHEN NEW RECORD INSTANCE TRIGGER
pop_list('ITEM NAME','QUERY');

If I use only one list item , it works fine. But I want to create multiple list item through record group in one form.

I have three column in Form and i populate the list item all these column. But when I call the above procedure in all item then only one list is populated and other dont. why?

any one help pls.

thanks in advance.
Farooq
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2005
Added on Jun 8 2005
2 comments
5,333 views