troubleshooting Question

loop having error

Avatar of chalie001
chalie001 asked on
DatabasesOracle DatabaseSQLMongoDB
5 Comments2 Solutions217 ViewsLast Modified:
hi how can i write this code better
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;		
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros