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

SHOW_LOV Built-in

Description

Displays a list of values (LOV) window at the given coordinates, and returns TRUE if the operator selects a value from the list, and FALSE if the operator Cancels and dismisses the list.

Syntax

SHOW_LOV
(lov_id LOV);

SHOW_LOV
(lov_id LOV,
x
NUMBER,
y
NUMBER);

SHOW_LOV
(lov_name VARCHAR2);

SHOW_LOV
(lov_name VARCHAR2,
x
NUMBER,
y
NUMBER);

Built-in Type unrestricted function

Returns BOOLEAN

Enter Query Mode yes

Parameters

lov_id 
 
Specifies the unique ID that Oracle Forms assigns the LOV when created. Use the FIND_LOV Built-in to return the ID to an appropriately typed variable. The data type of the ID is LOV.
 
lov_name 
 
The name you gave to the LOV when you defined it. The data type of the name is VARCHAR2.
 
x 
 
Specifies the x coordinate of the LOV.
 
y 
 
Specifies the y coordinate of the LOV.

Usage Notes

SHOW_LOV Restrictions

SHOW_LOV Examples

/*

** Built-in: SHOW_LOV
** Example: Display a named List of Values (LOV)
*/
DECLARE
a_value_chosen BOOLEAN;
BEGIN
a_value_chosen := Show_Lov('my_employee_status_lov');
IF NOT a_value_chosen THEN
Message('You have not selected a value.');
Bell;
RAISE Form_Trigger_Failure;
END IF;
END;