java - 如何从java调用oracle函数。函数返回数字

Question

我应该如何从 Java 调用 Oracle 函数？该函数应该返回一个数字。

        CallableStatement cstmt = mJConn.prepareCall("{? = call fnd_request.submit_request( application => 'FND', program => 'JAVACONINSERT', description => 'CSV to DB Insert via Java' ,start_time => sysdate ,sub_request => FALSE, argument1 => '/home/TEST/java/t1.txt')}");
            cstmt.registerOutParameter(1, Types.INTEGER);
            cstmt.executeUpdate();
            int reqId = cstmt.getInt(1);
        System.out.println(reqId);          

Answer 1

尝试更换

String call = "{?= CALL Proc(?)}";

与

String call = "{CALL Proc(?, ?)}";

前一种语法用于调用存储函数，新语法用于存储过程。

您还可以交换绑定(bind)参数的顺序:

cs.setString(1, "String");
cs.registerOutParameter(2, Types.INTEGER);