Oracle学习笔记（包基本结构）

function one(i_bill_id in number,i_bill_name in varchar2,o_err_msg out varchar) return Integer is result Integer;
m_count Integer;
begin
    begin
     .....
     commit;
     Result:=0;
     Exception when others then
      Result:=-1;
      o_err_msg:='错误';
      Rollback;
    end;
end;