loop having error

fdeclare

cursor get_emp_id is
    select id form emp_temp
	   where name = :block.itemName;
begin
for curr3 in get_emp_id loop
		
		wrk_curr_emp :=  GEN_CURRENT_empaccNo(curr3.id);
	
		
		if wrk_curr_nsn != curr3.id then
			message('this is not current accno');
			raise form_trigger_failure;
		else
			:block.idNr := curr3.id
		elsif wrk_curr_nsn != curr3.id  then
				:block.idnr := 	wrk_curr_emp;
			end if;
		--	end if;
		
	
		end loop;
end;		

Select all Open in new window