1.透過PL-SQL直接叫系統已設的LOV用法 :
 DECLARE
a_value_chosen BOOLEAN;
BEGIN
go_block('sis_registration');
enter_query(no_validate);
a_value_chosen := Show_Lov('lovreg');
IF NOT a_value_chosen THEN
Message('You have not selected a value.');
RAISE Form_Trigger_Failure;
else
execute_query;
END IF;
END;

 

2.

取消LOV:
 set_item_property('attendance_detail.employee_id',lov_name,'');

不能使用:
set_item_property('attendance_detail.employee_id',lov_name,null);

分配LOV:
set_item_property('attendance_detail.employee_id',lov_name,'employee_lov');