关于oracle的存储过程的思想与举例

1、使用PL/SQL，进入packages目录，new一个packege（输入名称等）；
2、对于package对象需要编辑body和spec，举例如下：
spec：
CREATE OR REPLACE PACKAGE chart_statistic IS
    v_Work_Begintime varchar2(50);--开始时间
     v_Work_Endtime varchar2(50);--结束时间
     v_Maindept varchar2(1);--文件步骤
    
      PROCEDURE Set_Work_Begintime ( p_Work_Begintime varchar,
                                    P_return_int OUT INTEGER,
                                    p_return_string OUT VARCHAR2);
     FUNCTION Get_work_Begintime RETURN VARCHAR2;

     PROCEDURE Set_Work_Endtime ( p_Work_Endtime varchar,
                                  P_return_int OUT INTEGER,
                                  p_return_string OUT VARCHAR2);
     FUNCTION Get_Work_Endtime RETURN VARCHAR2;

     PROCEDURE Set_Maindept ( p_Maindept varchar,
                              P_return_int OUT INTEGER,
                              p_return_string OUT VARCHAR2);
     FUNCTION Get_Maindept RETURN VARCHAR2;
END Char_Statistic;
body：
CREATE OR REPLACE PACKAGE chart_statistic IS
     PROCEDURE Set_Work_Begintime( p_Work_Begintime varchar,
                                    P_return_int OUT INTEGER,
                                    p_return_string OUT VARCHAR2) IS