可能比较简单的问题，返回数据集

[TechnoFantasy]

oracle存储过程如何返回数据集？
如何在Java中获得返回的数据集？

[xinpingf]

可以考虑使用plsql表

[mashansj]

利用数组实现

[nicholaz]

你需要写到一个包中：
create or replace package pag_cs_power as

type c_Type is ref cursor;

FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type;

end pag_cs_power;

存储过程代码：

FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type
as
c_cursor c_Type;
begin
open c_cursor for
select DICTID,DICTNAME FROM SYS_DICT WHERE DICTINDEX = v_DictIndex;
return c_cursor;
end FUN_CS_GETDICTLIST;

Java的代码：
String query = "begin :1 := pag_cs_power.FUN_CS_GETDICTLIST(:2); end;";
CallableStatement cstmt = conn.prepareCall(query);

cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setString(2, sIndex );

cstmt.execute();
ResultSet rset1 = (ResultSet)cstmt.getObject(1);

[nicholaz]

你需要写到一个包中：
create or replace package pag_cs_power as

type c_Type is ref cursor;

FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type;

end pag_cs_power;

存储过程代码：

FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type
as
c_cursor c_Type;
begin
open c_cursor for
select DICTID,DICTNAME FROM SYS_DICT WHERE DICTINDEX = v_DictIndex;
return c_cursor;
end FUN_CS_GETDICTLIST;

Java的代码：
String query = "begin :1 := pag_cs_power.FUN_CS_GETDICTLIST(:2); end;";
CallableStatement cstmt = conn.prepareCall(query);

cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.setString(2, sIndex );

cstmt.execute();
ResultSet rset1 = (ResultSet)cstmt.getObject(1);

[TechnoFantasy]

可以了，谢谢