Oracle Form重复记录校验方法(国外英语资料).docVIP

Oracle Form重复记录校验方法 ? Cux_com in this expression is a function of the Form in which you add functions in the program unit FUNCTION cux_com (str1 varchar2, str2 varchar2) RETURN number IS L_return number: = 0; The BEGIN IF str1 = str2 then L_return: = 1; The else L_return: = 0; End the if; Return l_return; The END; Add the when_validate_record trigger for the DUPBLOCK, and the code in the trigger is: Contorl.pre_data: = : dupbloc.line_number | | : dupbloc.item_number; If: contorl. Count_item 1 then Message ( there is duplicate data! ) -- fnd_message.debug ( there is duplicate data! ) Raise fo