I am following the forms help content to create a list from a record group. Below is documentation
Adding Multiple List Elements
To replace the elements in the List item completely, use the POPULATE_LIST Built-in subprogram. This subprogram removes the contents of the current List item and then populates the List item with the values from a record group.
A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. One advantage to populating a List item with record group values is that record groups (query and non-query) can be constructed dynamically at runtime.
Note: In order to populate a List item from a record group, the record group must be created at runtime and it must have two columns with type CHAR. Column one must contain List label values and column two must contain List element values.
When you call POPULATE_LIST, you indicate which List item will receive the record group values by specifying List ID and record group name.
Adding multiple List elements Examples
The following example creates a two column query record group and then populates a List item with the values from the record group.
DECLARE
group_id RecordGroup;
List_id Item := Find_Item('List_item1');
status NUMBER;
BEGIN
/*
** Create a two column query record group called
** product_name.
*/
group_id := Create_Group_From_Query('product_names','SELECT
product.name, product.name FROM product');
status := Populate_Group('product_names');
/*
** Populate the List item with the values from the
** product_name record group.
*/
Populate_List(List_id,group_id);
END;
I incorporated this list item into my form, the list seems to load up at times. But intermittently getting this error. An unexpected error has occured. Contact support Quote error FRM-40735
My record group query is below, which seems to be alright
rg_testamurtype := Create_Group_From_Query('testamur_types', 'SELECT testamur_type.testamur_type, testamur_type.description from testamur_type
where closed_ind = ''N'' order by testamur_type.description');
Please advise how to debug this.