oracle怎么返回多个select查询结果

[netajax1]

如题，用存储过程，怎么返回多个查询结果，调用怎么调
比如
sql1

select count(*)
  from test;

sql2

select * from test

谢谢
就和sqlserver直接拼接sql返回DataSet一样

[netajax1]

[itliyi]

CREATE OR REPLACE PROCEDURE Pro_Test(cur1 OUT sys_refcursor,
                                      cur2 OUT sys_refcursor) IS

BEGIN
  OPEN cur1 FOR select count(*) from test;
  OPEN cur2 FOR select count(*) from test;
end;

[itliyi]

OracleCommand cmd = new OracleCommand("Pro_Testd");
cmd.CommandType = CommandType.StoredProcedure;
//加参数
using (OracleConnection conn = new OracleConnection(""))
{
     OracleDataAdapter adapter = new OracleDataAdapter(cmd);
     DataSet ds = new DataSet();
     adapter.Fill(ds);
}

[EnForGrass]

必须使用 REF CURSOR 参考http://www.cnblogs.com/mikalshao/articles/1454134.html