I am currently coding Java in Websphere, using Struts. There is a procedure that I am executing that returns a number value, 0 or 1. Well, I cannot figure out how to retrieve this return value in java when executing the procedure. The code used to execute the procedure follows. The procedure was recently changed to return a value representing success or failure, which is why I need some change for the java code. The code to execute follows: sql3.append(" Begin "); sql3.append(" Execute Retire '"+updateSchedNo+"', '"+updateSchedLineNo+"','"+updateCoilId+"', '"+update+"'"); sql3.append(" End; "); sb3.prepareStatement(sql3.toString()); sb3.execute(); sb3.closeResources(); Where sql3 is a StringBuffer and sb3 is from a class named SQLBuilder that uses Connection and PreparedStatement from java.sql. The procedure is not Oracle, or this would be easier. It is a sql server procedure. If anyone can help, I'd really appreciate it... or if you need more info, just post and ask. Thanks!!