Re: code clean up help

k no_data_found --;

1.if i change these two count(*) to where i use exception, both results in no_data_found ..
i want to do different things for these two cases..

select count(*) into val
from schools s
where s.scname = newrowtsc_1;

        if (val = 1) then
select scid into home_school_id
from schools s
where s.scname = newrowtsc_1;
select count(*) into val
from teams t
where t.scid = home_school_id and

        t.sport = newrowtsport and
        t.gender = newrowtgender;
        if(val =1 ) then
        null;

2. if i use procedure, i should pass all variables to the procedure..? which might not be good...

thx for help though Received on Fri Sep 13 2002 - 06:00:31 CDT