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

GET_LOV_PROPERTY Built-in

Description

Returns information about a specified list of values (LOV).

You must issue a call to the Built-in once for each property value you want to retrieve.

Syntax

FUNCTION GET_LOV_PROPERTY
(lov_id LOV,
property NUMBER);

FUNCTION GET_LOV_PROPERTY
(lov_name VARCHAR2,
property
NUMBER);

Built-in Type unrestricted function

Returns VARCHAR2

Enter Query Mode yes

Parameters

lov_id 
 
Specifies the unique ID that Oracle Forms assigns the object at the time it creates it. Use the FIND_LOV Built-in to return the ID to an appropriately typed variable. The data type of the ID is LOV.
 
lov_name 
 
Specifies the name that you gave the object when creating it.
 
property 
 
Specifies the property you want to set for the given LOV. The possible properties are as follows:

AUTO_REFRESH Returns the VARCHAR2 string TRUE if the property is set to Yes; that is, if Oracle Forms re-executes the query each time the LOV is invoked. Returns the VARCHAR2 string FALSE if the property is set to No.

GROUP_NAME Returns the name of the record group currently associated with this LOV. The data type of the name is VARCHAR2.

HEIGHT Returns the height of the LOV. The size of the units depends on the Coordinate System and default font scaling you specified for the form.

WIDTH Returns the width of the LOV. The size of the units depends on the Coordinate System and default font scaling you specified for the form.

X_POS Returns the x coordinate that reflects the current placement of the LOV's upper left corner relative to the upper left corner of the screen.

Y_POS Returns the y coordinate that reflects the current placement of the LOV's upper left corner relative to the upper left corner of the screen.

GET_LOV_PROPERTY Examples

/*

** Built-in: GET_LOV_PROPERTY
** Example: Can get the width/height of the LOV.
*/
DECLARE
the_width NUMBER;
the_height NUMBER;
lov_id LOV;
BEGIN
lov_id := Find_LOV('My_LOV_1');
the_width := Get_LOV_Property(lov_id, WIDTH);
the_height := Get_LOV_Property(lov_id,HEIGHT);
END;