how to close unused open cursors

[partho mukherjee]

can we directly close the cursor declared in a CallableStatement without assinging it to a ResultSet?

[Jesper de Jong]

This question is not about SCJP.
Moving to JDBC forum.

[Jeanne Boyarsky]

Partho,
What Java object are you referring to? We have a Connection, CallableStatement and ResultSet object. Doesn't the ResultSet refer to the cursor?

[partho mukherjee]

I was referring to the Callablestatement object. I found that it has a method getParameterMetaData() in JDBC 3.0 which gives me some information about the parameters(in and out) declared in the CallableStatement.
But do we have anyway to refer to the parameters in a generic way if I am using an older version of JDBC?
I want to close all open cursors without having to refer to the ResultSet, i.e I have only the CallableStatement object at my disposal. Is there any way?