Switch Oracle Forms List of Values on and off dynamically at run time

In e.g. post-query block level trigger:

01IF block.check_field = 'F'
02THEN
03   -- switch on
04   Set_Item_Property( 'block.field' , LOV_NAME, 'your lov') ;
05   Set_Item_Property( 'block.field', VALIDATE_FROM_LIST, PROPERTY_TRUE);
06ELSE
07   -- switch off
08   Set_Item_Property( 'block.field' , LOV_NAME, '') ;
09   Set_Item_Property( 'block.field', VALIDATE_FROM_LIST, PROPERTY_FALSE);
10END IF ;

H/t François Degrelle

August 9, 2011

  • I was not able to implement switch off part in one of my forms, it helped me.
    Thank you 🙂

  • Suppose I am having 10 records then, in that case, It is overriding last record LOV to all available previous records.
    I am using the same logic in POST_QUERY Trigger at the block level.

  • Leave a Reply

    Your email address will not be published. Required fields are marked *