create or replace procedure sp_loggger(oi_task_id in out integer,ii_task_status in integer,iv_task_name in varchar2,iv_table_name in varchar2,iv_task_sign in varchar2,iv_task_log in varchar2,iv_task_pos in varchar2,ii_rowcount in integer default null)is begin if ii_task_status = 1 then select seq_logger.nextval into oi_task_id from dual;insert into logger(task_id,task_name,table_name,task_sign,start_time,end_time,task_status,task_log,task_pos,row_count)values(oi_task_id,iv_task_name,iv_table_name,iv_task_sign,sysdate,null,1,'程序运行中',null,null);elsif ii_task_status = 0 then update logger set end_time = sysdate,task_status = 0,task_log = '程序运行完成',row_count = ii_rowcount where task_id = oi_task_id;else update logger set end_time = sysdate,task_status = ii_task_status,task_log = substr(iv_task_log, 1, 200),task_pos = iv_task_pos,row_count = ii_rowcount where task_id = oi_task_id;end if;commit;exception when others then rollback;end;
创建存储过程
最新推荐文章于 2022-12-11 20:01:27 发布