Nested cursor loops in oracle stored procedures

Create or replace procedure statement is begin DECLARE -- query A set of www.2cto.com CURSOR c_number is select number186, money186 from xh_number_186_t A where. number186 in (select n. number186 from xh_number_186_t n minus select t. service_id from xh_codesource t where t. area_id = 'g000002'); r_number c_number % ROWTYPE; -- the loop begins with www.2cto.com begin open c_number; loop fetch c_number into r_number; exit when c_number % notfound; values ('Number = '| r_number.number186 |' = '| r_number.money186); insert into aa_t values (r_number.number186, r_number.money186); end loop; close c_number; end; delete from xh_codesource a where. service_id in (select t. service_id from xh_codesource t where t. area_id = 'g000002 'minus select n. number186 from xh_number_186_t n) and. area_id = 'g000002 '; end xh_number_186_diff_p;