create procedure Proc_test

    @Stat int=0,

    @MsgId varchar(50)='',

AS

BEGIN

        Update T_Mt Set Stat=@Stat,OStat=@Stat,RptTime=Getdate() Where MsgId=@MsgId

        If @@RowCount<1      --没有更新成功就插入到t_Statbuf

        insert into t_statbuf(MsgId,Stat,RptTime) values(@MsgId,@Stat,Getdate())

END  

CREATE OR REPLACE PROCEDURE test  

AS

BEGIN

    update MY_TIME_TEST1 set discript = '' where discript = '' ;

    If sql%rowcount>1  then  --上面update影响行数>1就插入到my_time_test1

    insert into MY_TIME_TEST1 values(sysdate,'');

    end if;

END;