Oracle函数中提交DML事务

格式如下：

create or replace function ModifySaleDate(
ps_OrgCode in varchar2,
ps_SaleNo in varchar2 ,
ps_POSNO in varchar2,
ps_xsdate in varchar2
)
return int
as
PRAGMA AUTONOMOUS_TRANSACTION;

代码示例：

create or replace function ModifySaleDate(
ps_OrgCode in varchar2,
ps_SaleNo in varchar2 ,
ps_POSNO in varchar2,
ps_xsdate in varchar2
)
return int
as
PRAGMA AUTONOMOUS_TRANSACTION;
       pi_Result int;
begin


  update tsalsale a
         set xsdate = to_date(ps_xsdate||' '||to_char(xsdate , 'hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') , 
         jzdate = ps_xsdate
         where orgCode = ps_OrgCode and saleNo = ps_SaleNo and POSNO = ps_POSNO;

  update tSalSalePlu a
         set xsdate = to_date(ps_xsdate||' '||to_char(xsdate , 'hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')
         where orgCode = ps_OrgCode and saleNo = ps_SaleNo;

   commit;
   
   select count(*) into pi_Result from tsalsale a where a.xsdate = to_date(ps_xsdate||' '||to_char(xsdate , 'hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') and a.jzdate = ps_xsdate;
   select count(*) into pi_Result from tSalSalePlu a where a.xsdate = to_date(ps_xsdate||' '||to_char(xsdate , 'hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') ;

Return(pi_Result);
end ModifySaleDate;