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

FIND_LOV Built-in

Description

Searches the list of LOVs and returns an LOV ID when it finds a valid LOV with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of LOV.

Syntax

FUNCTION FIND_LOV
(LOV_name VARCHAR2);

Built-in Type unrestricted function

Returns LOV

Enter Query Mode yes

Parameters

LOV_name 
 
Specifies the valid VARCHAR2 LOV name.

FIND_LOV Example

/*

** Built-in: FIND_LOV
** Example: Determine if an LOV exists before showing it.
*/
DECLARE
lv_id LOV;
status BOOLEAN;
BEGIN
lv_id := Find_LOV('My_Shared_LOV');
/*
** If the 'My_Shared_LOV' is not part of the current form,
** then use the 'My_Private_LOV' instead.
*/
IF Id_Null(lv_id) THEN
lv_id := Find_LOV('My_Private_LOV');
END IF;
status := Show_LOV(lv_id,10,20);
END;


Referencing Oracle Forms Objects by Internal ID