Hi All,
Need Your help.
I am populating a control block with below procedure. Problem is even if i have 1 records, message('NO RECORD'); is firing. please suggest what is my mistake.
PROCEDURE pop_search IS
cursor cur_fetch is
select * from ccc_reschedule where outcome in ('Requested','Not Rescheduled');
c cur_fetch%rowtype;
begin
go_block('ccc_reschedule');
clear_ccc;
first_record;
open cur_fetch;
loop
fetch cur_fetch into c;
--exit when cur_fetch%notfound;
if cur_fetch%notfound then
message('NO RECORD'); -- query returned no rows message
exit;
END IF;
:ccc_reschedule.work_request := c.wr_no;
next_record;
end loop;
first_record;
END;
Regards,
Balaji