yes, so use that perfect standard compliant API.

Hibernate's support for stored procedures does not cover out parameters.

/max

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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev

_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev

Reply via email to