You can delete List elements one at a time or you can clear the entire List.
There are three Built-in subprograms that can be used to delete elements from a List item:
Note: Do not delete a List element or clear a List if the List item's Mapping of Other Values property is set to No and a query is open. Doing so may cause Oracle Forms to be unable to display records that have already been fetched.
For example, assume that a List item contains the values A, B, and C and the Mapping of Other Values property is set to No. Assume also that these values have been fetched from the database ( a query is open). At this point, if you delete a List element, 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 an element was deleted.
Before deleting an element, check for open queries and then use the ABORT_QUERY Built-in subprogram to close any open queries.
Manipulating List items at runtime