Hi,
Hope this will help u
Here the procedure takes 4 integers as parameters
CallableStatement cStmt = null;
try {
cStmt = conn.prepareCall(" { call <proc name>(?,?,?,?)}");
cStmt.setInt(1,<varname1>
;
cStmt.setInt(2,<varname2>
;
cStmt.setInt(3, <varname3>
;
cStmt.setInt(4, <varname4>
;
cStmt.executeUpdate();
}
catch(Exception e){
e.printStackTrace();
} // end of the try-catch block
finally{
try {
cStmt.close();
conn.close();
}
catch(Exception e){}
} // end of the finally block
regards
Raja