I am using MS SQL Server and
Java How can i use IN and Out Parameters when i am calling SQL SERver Stored procedure. I am using the following method,
con1=DriverManager.getConnection("jdbc
dbc:mydsn","uid","pwd");
CallableStatement cs = con1.prepareCall("{call showEcode}");
ResultSet rs = null;
rs = cs.executeQuery();
in the above i want to pass as
string paramenter and similaryly i want to receive a string parameter
ShowEcode is the SQL Server Procedure
but i dont't know how to use IN and Out Parameters(both are string) in the above.
can anybody help me?