如何调用oracle的存储过程？

Question

调用PACKAGE是
如果里面有function那PACKAGE.function
以一样

Answer 1

或者直接("{call PACKAGE(?)}");

Answer 2

如何得到返回的值呢？这样附制可以的吧
callStatement.setString(0,array[0]);那如何得到返回的值呢？

Answer 3

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            String strUrl="jdbc:oracle:thin:@172.16.14.94:1521:gadb";            Properties props = new Properties();
            props.put("user",     "developer");
            props.put("password", "developer");
            //props.put("weblogic.codeset","gb2312");
            conn = DriverManager.getConnection(strUrl,props);
            //callstatement = conn.prepareCall("{call packperson.allperson(?,?,?)}");
            callstatement = conn.prepareCall("{call packperson.allnum(?)}");
            callstatement.registerOutParameter(1,java.sql.Types.INTEGER);
            callstatement.registerOutParameter(2,java.sql.Types.CHAR);
            callstatement.registerOutParameter(3,java.sql.Types.CHAR);            callstatement.executeQuery();