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 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 at 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):
[code type="PL/SQL"]Begin
   If Show_Lov('My_Lov') Then
      Message('Value Choosen.');
   Else
      Message('Value Not Choosen');
   End If;
End;[/code]
OR
[code type="PL/SQL"]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;[/code]
Below is the example given to call Show_Lov function by passing LOV ID as parameter, by using Find_Lov and ID_Null functions.
[code type="PL/SQL"]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;[/code]

Show_Lov Example Oracle Forms

Ask Your Questions By Comment Below.

Example is given to show LOV in Oracle Forms using Show_Lov function. Show_Lov command syntax details also given.

Post a Comment

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.