Java:如何从 Oracle 打印存储过程数据

Question

如何在 Oracle 数据库中创建 System.Out.println 存储过程。如您所见，存储过程返回数据库版本横幅。现在我想在 java 控制台中打印该横幅。

我的存储过程是:

CREATE OR REPLACE PROCEDURE getVersion (out_cursor OUT SYS_REFCURSOR)
AS
BEGIN
   OPEN out_cursor FOR SELECT * FROM V$VERSION;
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      DBMS_OUTPUT.put_line (SQLERRM);
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line (SQLERRM);
END getVersion;

Java代码:

      System.out.println("Connecting to a selected database...");
      conn = DriverManager.getConnection(DB_URL, USER, PASS);
      System.out.println("Connected database successfully...");

      //CREATE procedure
      Statement stmtpr = conn.createStatement();
      // Create the stored function
      stmtpr.execute("CREATE OR REPLACE PROCEDURE getVersion (out_cursor OUT SYS_REFCURSOR) AS BEGIN OPEN out_cursor FOR SELECT * FROM V$VERSION; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line (SQLERRM); WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM);END getVersion;");
      // Close the statement
      System.out.println("PROCEDURE created!!! ");
      stmtpr.close();

      //Execute a query
      System.out.println("Creating statement...");
      CallableStatement stmtpro = conn.prepareCall("BEGIN getVersion(?); END;");
      stmtpro.registerOutParameter(1, OracleTypes.CURSOR);
      stmtpro.execute();
      ResultSet rs = ((OracleCallableStatement) stmtpro).getCursor(1);
      while (rs.next()) {
        System.out.println(rs));    //How to print BANNER data
      }

      rs.close();
      stmtpro.close();
      conn.close();

Answer 1

好吧，你必须使用列名称，在本例中它是 banner 我猜，所以尝试作为

System.out.println(rs.getString("banner"));