Hi,
Oracle forms 6i,
Oracle Database 11.2.0.4
I need to compare length of 2 text fields in tabular detail block and store ‘Y’ if all records are same or store ‘N’ even if 1 record is different. I tried below code, but its not working properly. It shows Y even if 1 record matches.
declare
print_flag varchar2(1);
Begin
go_block('REQUISITION_DETAIL');
first_record;
print_flag:='N';
while (:REQUISITION_DETAIL.part_DESCRIPTION is not null and :REQUISITION_DETAIL.RDTL_QTY is not null)
loop
if length(LTRIM(RTRIM(:REQUISITION_DETAIL.NON_STOCK_ITEM_DESC))) = length(LTRIM(RTRIM(:REQUISITION_DETAIL.LONG_DESC_HOLD)))
then print_flag:='Y';
end if;
next_record;
end loop;
first_record;
End;