Java调用oracle 存储过程返回结果集(record)
首先创建2个type类型, ,我可以把record记录集里的内容赋给type对象类型,在给游标返回!
假如环境是在scott/tiger用户下
创建type定义你要返回的字段!
drop type myScalarType;
drop type myTableType;
create or replace type myScalarType as object (rno number(18),rname number(18),rsal number(18));
create or replace type myTableType as table of myScalarType;
创建PACKAGE
CREATE OR REPLACE PACKAGE TESTPACKAGE AS
type type_cursor is ref cursor;
end TESTPACKAGE;
创建PROCEDURE
CREATE OR REPLACE PROCEDURE test_items(MyTable out
TESTPACKAGE.type_cursor)IS
BEGIN
Declare
Type RecType Is Record
(
rno number(18),
rname number(18),
rsal number(18)
);
Type TabType Is Table Of RecType Index By Binary_Integer;
MyTab TabType;
obj_type_tab MYTABLETYPE := MYTABLETYPE();
vN Number;
Begin
--填充你要组装的字段
vN := 1;
MyTab(vN).rno := '00000';
MyTab(vN).rname := '11111';