A script-enabled browser is required for this page to function properly.

RETRIEVE_LIST Built-in

Description

Retrieves and stores the contents of the current list into the specified record group. The target record group must have the following two-column (VARCHAR2) structure:

Column 1: Column 2:

the list label the list value

Storing the contents of a list item allows you to restore the list with its former contents.

Syntax

PROCEDURE RETRIEVE_LIST
(list_id ITEM,
recgrp_name
VARCHAR2);

PROCEDURE RETRIEVE_LIST
(list_id ITEM,
recgrp_id RecordGroup);

PROCEDURE RETRIEVE_LIST
(list_name VARCHAR2,
recgrp_id
RecordGroup);

PROCEDURE RETRIEVE_LIST
(list_name VARCHAR2,
recgrp_name
VARCHAR2);

Built-in Type unrestricted procedure

Returns VARCHAR2

Enter Query Mode yes

Parameters

list_id 
 
Specifies the unique ID that Oracle Forms assigns when it creates the list item. Use the FIND_ITEM Built-in to return the ID to an appropriately typed variable. The data type of the ID is ITEM.
 
list_name 
 
The name you gave to the list item when you created it. The data type of the name is VARCHAR2.
 
recgrp_id 
 
Specifies the unique ID that Oracle Forms assigns when it creates the record group. The data type of the ID is RecordGroup.
 
recgrp_name 
 
The VARCHAR2 name you gave to the record group when you created it.

RETRIEVE_LIST Examples

/*

** Built-in: RETRIEVE_LIST
** Example: See POPULATE_LIST
*/