怎样让Oracle的存储过程返回结果集

Oracle存储过程:JavaEye有BUG,贴不出PL/SQL代码,只好贴图片了!!!

?

Java调用代码:

    try {          DriverManager.registerDriver (new oracle.jdbc.OracleDriver());          Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora10g", "user", "user");                    CallableStatement stmt = conn.prepareCall("BEGIN GETCITY(?, ?); END;");          //CallableStatement stmt = conn.prepareCall("{ call GETCITY(?, ?) }");                    stmt.setString(1, "021");           stmt.registerOutParameter(2, -10 /* OracleTypes.CURSOR = -10 */); //REF CURSOR(OracleTypes.CURSOR==-10)          stmt.execute();          ResultSet rs = (ResultSet) stmt.getObject(2);          while (rs.next()) {            System.out.println(rs.getString("CITY_NAME"));           }          rs.close();          rs = null;          stmt.close();          stmt = null;          conn.close();          conn = null;        }        catch (SQLException e) {          System.out.println(e.getLocalizedMessage());        }

?

1 楼 chengzanda 2010-07-02 这个东西写的真好，精简实用 2 楼 DataBird 2011-01-26 好，民工写的东西就是朴实易懂，不玩高深，呵呵。
我的异常网推荐解决方案：oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html