Display LOV (List Of Values) Using Show

鄂破机看

Show_Lov Function is used to display list of values (LOV) in Oracle Forms. It returns TRUE if the user selects a value from the list, and FALSE if user not selects the value.

Syntax

You can pass the LOV>　　SHOW_LOV(lov_id LOV);

　　You can pass the x and y coordinates with LOV>　　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 given to call Show_Lov function by passing LOV>  Declare
lv_id LOV;
v_choosen Boolean;
Begin
lv_id := Find_LOV('My_LOV');

If Not>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;