Re: Update ****Return boolean checking condition in multiple records *** [message #37815] |
Thu, 28 February 2002 17:24 |
epro
Messages: 11 Registered: January 2002
|
Junior Member |
|
|
Exactly, you are right, in addition,
in 2 scenarios we return FALSE.
==================================
1)when dept <> A or B or C.
2)if dept = C, and if other procedure(is called from this functin), does NOT return C1.
===================================
if I write like this
==============================
begin
for c_rec in c
loop
if c_rec.dept in ('A','B') then
return true;
elsif c_rec.dept = c then call_proc(emp_num,v_out)
if v_out = c1 then
return true;
end if;
end if;
end loop;
return false;
end;
=====================================================
I wonder if it works.
Thanks Todd,
|
|
|