--创建测试表
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