Oracle中调用带有返回参数的存储过程

--创建测试表

create table EMP (EMPNO number , ENAME varchar2(32) );

insert into EMP (EMPNO ,ENAME) values (10,'张三');

insert into EMP (EMPNO ,ENAME) values (20,'小马');

insert into EMP (EMPNO ,ENAME) values (30,'小米');

insert into EMP (EMPNO ,ENAME) values (40,'小明');

--创建存储过程

 CREATE OR REPLACE PROCEDURE PROC_TEST(V_STR      IN VARCHAR,
                                      UPD_ROWS   OUT NUMBER,
                                      INSET_ROWS OUT NUMBER) IS

  UPDATE_ROWS NUMBER(10) := 0;
  INSERT_ROWS NUMBER(10) := 0;
  CURSOR CURSOR_EMP IS
    SELECT EMPNO, ENAME FROM EMP;
  CUR_EMP_OBJ CURSOR_EMP%ROWTYP