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!

populate list item, gives error FRM-41331

690743Jul 4 2009 — edited Jul 5 2009
i want to populate a list item based on value entered in a text field.
the text field is fth_code and if the value of fth_code is 'PMT' populate list fth_party_code with "SUPL"
and if it is "RCT" then populate fth_party_code "CUST".

i wrote this in the WVI OF FTH_CODE.
but when i run form and enter value in fth_code,i get error,

frm-41331 Could not delete element from fth_party_code.
DECLARE
SUPL varchar2(200) := 'SELECT SUPL_NAME,SUPL_CODE FROM SUPPLIER_MASTER'; 
CUST varchar2(200) := 'SELECT CUST_NAME,CUST_CODE FROM CUSTOMER_MASTER'; 

v_rg_id recordgroup;
v_err NUMBER:= 0;

BEGIN
IF  :FTH_CODE = 'PMT' THEN
		v_rg_id := create_group_from_query('recgrp1',SUPL);
ELSIF :FTH_CODE = 'RCT' THEN
		v_rg_id := create_group_from_query('recgrp1',CUST);
END IF;

v_err:= populate_group(v_rg_id);

clear_list('FTH_PARTY_CODE');
populate_list('FTH_PARTY_CODE',v_rg_id);
DELETE_GROUP(v_rg_id);
END;
please anyone can suggest what is the problem actually? thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2009
Added on Jul 4 2009
3 comments
1,233 views