sp_reckoningappend.sql

一整套的源代码

create or replace function sp_reckoningappend
return integer
is
  l_reckoningid integer;
begin
  select reckoning_id.nextval into l_reckoningid from dual;
  insert into reckoning
  (
    reckoningid,
    created,
    updated,
    charge,
    isactive,
    isvalid,
    sickid
  )
  values
  (
    l_reckoningid,
    sysdate,
    sysdate,
    0,
    0,
    0,
    null
  );
  return l_reckoningid;
end;
/