create or replace procedure check_records (ikbid in number,ikch in varchar2 ,ixh in varchar2,ixnd in varchar2,ikkxq in varchar2,info out varchar2,msg out varchar2)
as
v1 number;
v2 number;
v3 number;
begin
select XZRS into v2 from KCB_JW where KCH=ikch;
select count(*) into v3 from KB_JW where KBID= ikbid;
select count(*) into v1 from KB_JW where KCH= ikch and XH= ixh and XND= ixnd and KKXQ=ikkxq ;
if (v1>0) then
begin
info :='exist';
end;
Else
if(v3<v2) then
begin
insert into KB_JW (XH,KBID,KCH,XND,KKXQ) values(ixh,ikbid,ikch,ixnd,ikkxq);
msg :='success';
end;
ELSE
begin
msg :='over';
end;
end if;
end if;
end check_records;
oracle 存储过程
最新推荐文章于 2024-09-25 14:30:16 发布