I need to call a PLSQL which has two arguments. First is an "OUT", and the second is an "IN" variable. Encrypt(cryptpass, input) - No return value. You pass it "input", and it passes back "cryptpass". How can I get access to "cryptpass" via JDBC ( in java/JSP ) ( This is a simple example, a lot of other stored procedures have more than one "return" value )
posted 14 years ago
After callablestat.execute() - For a single or multiple values being returned by stored procedures as OUT parameters, use : String cryptPass = callablestat.getString(1); int resultInt = callablestat.getInt(n); etc. If the stored procedure is returning a cursor, use : ResultSet rst = ((OracleCallableStatement)callablestat).getCursor(3); and then : rst.get.....