Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Capturing output parameters in Java w/SQL Server 2000 stored procedure
The following should work: java.sql.CallableStatement stmt = con.prepareCall("{call proc_name (?, ?, ...)}"); stmt.setXXX(1, yyy); stmt.setXXX(2, yyy); ... stmt.execute(); rs = (java.sql.ResultSet) stmt.getResultSet(); Access your return values through the first row of the...
