Callable Statements

From: redglow (redglow_at_freenet.de)
Date: 01/21/04 

Date: Wed, 21 Jan 2004 16:08:48 +0100

Hello

Knows anyone about calling Stored Procedures in Java?

Sample-Src:

I try to call a Procedure in MSSQL Server 2000

String sql = "{? = call " + strProc + "(?,?,?)";
CallableStatement cs = curConn.prepareCall(sql);
cs.setString(1,"hello");
cs.setInt(2,1);
cs.registerOutParameter(3,java.sql.Types.VARCHAR);

ResultSet rsTemp = cs.executeQuery();

Occuring Errors:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Ungültiger Parameter Einbindung(en).

I dont know why this error occurs?
Anybody out there who can help me?

Rico