Friday, March 13, 2009

How to call a Stored Procedure from JDBC (JDBC)

Question :How to call a Stored Procedure from JDBC? (JDBC)
Answer :The first step is to create a CallableStatement object. As with Statement
an and PreparedStatement objects, this is done with an open Connection
object. A CallableStatement object contains a call to a stored procedure.
E.g.
CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");
ResultSet rs = cs.executeQuery();

No comments: