Display LOV (List Of Values) Using Show_Lov In Oracle Forms

Syntax

You can pass the LOV ID to Show_Lov function to display the LOV.

SHOW_LOV(lov_id LOV);

You can pass the x and y coordinates with LOV ID to display LOV the t specific location.

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

Display LOV by passing the LOV Name.

SHOW_LOV (lov_name VARCHAR2);

By passing LOV Name with X and Y coordinates.

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

Example

When-Button-Pressed trigger to display LOV (list of values):

Begin
If Show_Lov('My_Lov') Then
Message('Value Choosen.');
Else
Message('Value Not Choosen');
End If;
End;
OR
Declare
v_choosen boolean;
Begin
v_choosen := Show_Lov('My_Lov');
If v_choosen Then
Message('Value Choosen.');
Else
Message('Value Not Choosen');
End If;
End;

Declare
lv_id LOV;
v_choosen Boolean;
Begin
lv_id := Find_LOV('My_LOV');
If Not Id_Null(lv_id) THEN
v_choosen := Show_LOV(lv_id,10,20);
End If;
If v_choosen Then
Message('Value Choosen.');
Else
Message('Value Not Choosen');
End If;
End;