Show_Lov Function is used to display the list of values (LOV) in Oracle Forms. It returns TRUE if the user selects a value from the list, and FALSE if the user does not select the value.
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;
Below is the example is given to call Show_Lov function by passing LOV ID as a parameter, by using Find_Lov and ID_Null functions.
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;
See also:
How can I show a lov items into list of item ?