Search This Blog

Monday, March 11, 2013

change Oracle Forms Lov Title Programatically


   you can create program unit in oracle forms to be called when needed and you may even put it in object library but the below example is fixed you may improve it to be dynamically depending on tables entry


check this out

--List Of Value


PROCEDURE Set_LOVs IS V_ERR VARCHAR2(200);

 BEGIN IF :Global.Lang = 1 THEN Set_LOV_Property('LOV_STD_TYPE_DESC', TITLE, 'lov title 1 lang 1');

 Set_LOV_Column_Property('LOV_TYPE_DESC', 1, TITLE, 'first col desc title lang 1');

 Set_LOV_Column_Property('LOV_TYPE_DESC', 2, TITLE, 'second col desc title lang 1');
ELSE Set_LOV_Property('LOV_TYPE_DESC', TITLE, 'lov title 2 lang 2');

 Set_LOV_Column_Property('LOV_TYPE_DESC', 1, TITLE, 'first col desc title lang 2');
 Set_LOV_Column_Property('LOV_TYPE_DESC', 2, TITLE, 'second col desc title lang 2);
 END IF;

 EXCEPTION WHEN OTHERS THEN V_ERR := SQLERRM;

END;

No comments:

Post a Comment