Calling a stored procedure for MSSQL 2000?

Oct 15, 2008 14:46:00

I have a select statement in a stored procedure that returns all the columns from a table.
I have done it before with Oracle using Oracle cursers. But I am not sure how to set the type for JDBC's CallableStatement.registerOutParameter() while using MS SQL Server. Any ideas?

For my next feat, I will require a volunteer from the audience! Perhaps this tiny ad?

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com