oracle存储过程创建及调用

创建

create or replace procedure getweeksy(pdate IN VARCHAR2,
                                  v_OutputCode OUT VARCHAR2,
                                  v_OutPutMsg  OUT VARCHAR2) IS
s_date varchar2(10);                                  
begin
  s_date := to_char(to_date(pdate,'yyyymmdd')-7,'yyyymmdd');                                

	pkgprofitanalyse6.sp_EntireIIRatioDetail(s_date,pdate,'taccoinfo','bf_dzd') ;

    v_OutputCode := '0000';
    v_OutPutMsg  := '获取时间参数之前一周之内的收益计算成功';
  
  EXCEPTION
    WHEN OTHERS THEN
      v_OutputCode := '0001';
      v_OutPutMsg  := '获取时间参数之前一周之内的收益计算发生异常' || SQLCODE || '---' || SQLERRM;
      ROLLBACK;
      RETURN;
  END;

plsql调用存储过程：

declare 
v_OutputCode  VARCHAR2(10);
v_OutPutMsg   VARCHAR2(100);
begin
  getweeksy('20161231',v_OutputCode,v_OutPutMsg);
  DBMS_OUTPUT.PUT_LINE(v_OutputCode);
END;