create or replace procedure noahark.Pro_basic_inter_entity_apps as v_entitycode tbl_basic_inter_entity_apps.centitycode%type;
v_entitytypename tbl_basic_inter_entity_apps.centityname%type;
v_bisend tbl_basic_inter_entity_apps.bisend%type;
i number:=1;
cursor c1 is
select centitycode,casstypecode,ire from noahark.asstype_apps;
begin
open c1;
for i in 1..4 loop
fetch c1 into v_entitycode,v_entitytypename,v_bisend;
if v_bisend = null then
v_bisend = 1;
end if;
insert into tbl_basic_inter_entity_apps(centitycode,centityname,ilevel) values(v_entitycode,v_entitytypename,v_bisend);
COMMIT;
end loop;
close c1;
end;
我是想判断V_BISEND如果为NULL 就让V_BISEND = 1,总是编译不过去.不知道为什么?
v_entitytypename tbl_basic_inter_entity_apps.centityname%type;
v_bisend tbl_basic_inter_entity_apps.bisend%type;
i number:=1;
cursor c1 is
select centitycode,casstypecode,ire from noahark.asstype_apps;
begin
open c1;
for i in 1..4 loop
fetch c1 into v_entitycode,v_entitytypename,v_bisend;
if v_bisend = null then
v_bisend = 1;
end if;
insert into tbl_basic_inter_entity_apps(centitycode,centityname,ilevel) values(v_entitycode,v_entitytypename,v_bisend);
COMMIT;
end loop;
close c1;
end;
我是想判断V_BISEND如果为NULL 就让V_BISEND = 1,总是编译不过去.不知道为什么?
v_bisend := 1;
end if;