从Java中的Oracle中的存储过程获取ResultSet [英] Get ResultSet from Stored Procedure in Oracle from Java

问题描述

我一直在论坛中浏览许多与我的问题有关的帖子，但没有任何帮助，所以我正在发布我的问题. 我在Oracle(11g)中有一个SP，该SP应该返回结果集. SP如下所示:

I've been looking through many posts in the forum related to my problem but I nothing helped me, so I'm posting my problem. I have a SP in Oracle (11g) that is suppossed to return a Result Set. The SP looks like follows:

CREATE OR REPLACE
PROCEDURE testProc
(
  tableName IN VARCHAR2,
  INFORMATION OUT SYS_REFCURSOR
) AS 
  sqlQuery varchar2(1000);
BEGIN
  sqlQuery := 'SELECT ID||''|''||Name||''|''||Surname FROM '||tableName;
  OPEN INFORMATION FOR sqlQuery;
END GETVALIDATIONPECLOG;

我从Java调用它的方式是

And the way I'm calling it from java is

...
CallableStatement cs = null 
cs = connection.prepareCall("{call getvalidationpeclog(?,?)}");
cs.setString(1, table);
cs.registerOutParameter(2, OracleTypes.CURSOR);
System.out.println("AS: " + cs.execute()); //Returns false
rs = (ResultSet) cs.getObject(2);
while (rs.next()) {
   bw.write(rs.getString(1));
   bw.newLine();
}
...

但是你猜怎么着?根本不起作用...我想念什么?谢谢！

but guess what? It doesn't work at all... What am I missing? Thanks !

推荐答案

确定.对不起，我的错.我没有关闭BufferedWriter ...该代码确实很好用.

OK. Sorry my fault. I wasn't closing the BufferedWriter... That code works really fine.

这篇关于从Java中的Oracle中的存储过程获取ResultSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！