Re: [hibernate-dev] Register Out Parameters in a Stored Procedure

Hi Hibernate devs .. I need to execute a stored procedure in DB2 ... The problem is that i don´t know how to register an out parameter to the stored procedure. With simple Callable statement would be something like: String query = "{call P5PORC_CONSULTAR_CUPO_CLIENTE (?,?,?,?,?)}"; CallableStatement cstmt = con.prepareCall(query); cstmt.setString(1, "1234"); cstmt.registerOutParameter(2, Types.VARCHAR ); cstmt.registerOutParameter(3, Types.INTEGER); cstmt.registerOutParameter(4, Types.VARCHAR); cstmt.registerOutParameter(5, Types.VARCHAR); cstmt.executeUpdate(); Thanx ... ------------------------------------------------------------------------ _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev