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;
posted @ 2011-07-25 14:48  Grace Dream  阅读(196)  评论(0编辑  收藏  举报