LATEST CODE
========================================================================
Stored procedure : CREATE_fix_link
Number of params : CREATE PROCEDURE CREATE_fix_link (.......there are 34 params ...of which 33 are input params and last one 34th is varchar output)--->
========================================================================

JAVA-- (What is wrong as i get JZ0R2: No result set for this query )
========================================================================
// Estabilish a connection to databse and make a connection object...Connection connection =......
// Prepare the callable Statement to construct the call to SP
CallableStatement cstmt=connection.prepareCall("{?=call CREATE_fix_link(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?.?,?,?,?,?,?,?,?)}");
// NOW THERE ARE 34 ?'s for all i/p plus o/p param..
cstmt.registerOutParameter(1,Types.VARCHAR); // for return type.
cstmt.registerOutParameter(35,Types.VARCHAR);// for last o/p param
cstmt.setString(2,LinkName);........
// these are the names of the params defined in SP
....................................................
....................................................
cstmt.setString(34,LinkExchGroups);

// Now Call the stored procedure
ResultSet results=cstmt.executeQuery();
while (results.next())

{
String rslt=results.getString(35);
}

// free connection
..................

COMPILE FINE BUT ON CLICKING SUBMIT BUTTON ON GUI WHICH ONVOKES THIS SERVLET WHICH CONTAINS THIS JAVA CODE CALLING "SP"

JZ0R2: No result set for this query..
I am so frustrated ..pls help me out here!!!!!