oracle创建简单的存储过程

create or replace procedure test1(
       param1 in number,    --传入参数1
       param2 in varchar2,    --传入参数2
       res out varchar2，    --返回参数
       ...      
) is
  cus_param1 number;      --自定义变量1
  cus_param2 varchar2(20);      --自定义变量2
begin
  null;      --处理逻辑的sql
end test1;

create or replace procedure test2(bf_id in number,status in number,res out varchar2) is
  count_num number;
begin
  select count(*) into count_num from sft_sys_bfinfo where bfid=bf_id;
  if count_num > 0 then
    begin
     update sft_sys_bfinfo set tj_cfg=status where bfid=bf_id;
    end;
  end if;
  commit;
  res := '成功';
Exception
  When others then
    Dbms_output.Put_line(sqlerrm); --打印输出错误
    Rollback; --回滚事务
    dbms_output.put_line('存储过程执行异常,事物回滚！');
    res := '失败';
end test2;

select count(*) into count_num from sft_sys_bfinfo where bfid=bf_id;

res :='成功'

if count_num > 0 then
   begin
    update sft_sys_bfinfo set tj_Cfg=status where bfid=bf_id;
   end;
end if;

commit;

Exception
  When others then
    Dbms_output.Put_line(sqlerrm);          --打印输出错误
    Rollback;                               --回滚事务
    dbms_output.put_line('存储过程执行异常,事物回滚！');
    res := '失败';

select count(*) into count_num from sft_sys_bfinfo where bfid=bfid;

select count(*) into count_num from sft_sys_bfinfo where bfid=bf_id;