oracle存储过程返回游标 java_Java jdbc调用oracle存储过程返回游标例子

1.创建测试表

create table users(

userid int primary key,

username varchar2(20),

userpwd  varchar2(20)

);

insert into users values(1,'test','test');

insert into users values(2,'test','test');

insert into users values(3,'test','test');

insert into users values(4,'test','test');

insert into users values(5,'test','test');

insert into users values(6,'test','test');

insert into users values(7,'test','test');

2.创建存储过程

创建包

create or replace package pkg_test

as

type cursor0 is ref cursor;

procedure get(p_id int,p_rc out cursor0);

end pkg_test;

创建包的内容

create or replace package body pkg_test as

procedure get(p_id int, p_rc out cursor0) is

begin