| List Item Population [message #411814] |
Tue, 07 July 2009 00:04  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear all
I have two list items, list_item1 and list_item2. I am creating and populating list_item2 at when_list_changed trigger of list_item1 but it is not working and give me error CAN NOT POPULATE THE LIST
declare
rg_id recordgroup;
rg_name varchar2(40) := 'MY_LIST';
rn number;
begin
rg_id := find_group( rg_name );
if id_null(rg_id) then
rg_id := create_group_from_query(rg_name,'select cu_frst_nam, cu_usrid ' ||'from comm_users '
||'where cu_cd_dcode = ||:trm_t_cd_dcode
||'order by 1');
else
delete_group(rg_id);
rg_id := create_group_from_query(rg_name,'select cu_frst_nam, cu_usrid ' ||'from comm_users '
||'where cu_cd_dcode = '||:trm_t_cd_dcode
||'order by 1');
end if;
rn := populate_group(rg_id);
populate_list('trm_on_request',rg_id);
end;
|
|
|
|
|
|
| Re: List Item Population [message #411878 is a reply to message #411838] |
Tue, 07 July 2009 04:09  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear VAMSI thanks for the reply.
usrid field is already varchar2 and after adding of space, problem not resolved.
Exact error is
FRM-41337: Cannot populate the list from recordgroup.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
