The first step is to create a CallableStatement object. As with Statement and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.

CallableStatement cs =

con.prepareCall("{call SHOW_SUPPLIERS}");

ResultSet rs = cs.executeQuery();