oracle ´æ´¢¹ý³Ì

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;