try this:create or replace procedure noahark.Pro_basic_inter_entity_apps as  v_entitytypename tbl_basic_inter_entity_apps.centityname%type;
 v_bisend   tbl_basic_inter_entity_apps.bisend%type;  
 cursor c1 is
    select casstypecode,ire from noahark.tbl_basic_inter_asstype_apps;
begin
open c1;
--for i in 1..4 loop
fetch c1 into v_entitytypename,v_bisend;
insert into tbl_basic_inter_entity_apps(centitycode,ilevel) values(v_entitytypename,v_bisend);
COMMIT;
--end loop;
end;