Clears all elements from a list item. After Oracle Forms clears the list, the list will contain only one element (the null element), regardless of the item's Required property.
Built-in Type unrestricted procedure
Enter Query Mode yes
For example, assume that a list item contains the values A, B, and C and the Mapping of Other Values property is defined. Assume also that these values have been fetched from the database (a query is open). At this point, if you clear the list with CLEAR_LIST, an error will occur because Oracle Forms will attempt to display the previously fetched values (A, B, and C), but will be unable to because the list was cleared.
Before clearing a list, close any open queries. Use the ABORT_QUERY Built-in to close an open query.
Note: The block status is QUERY when a block contains queried records. The block status is CHANGED when a block contains records that have been either inserted or updated (queried records have been modified).
When either the default value or other values element cannot be deleted, CLEAR_LIST leaves these elements in the list and clears all other elements. Refer to the restrictions on DELETE_LIST_ELEMENT for more information.
/*
** Built-in: CLEAR_LIST
** Example: See POPULATE_LIST
*/