Oracle stored procedure result set ref problem

[Ali Gohar]

Hi,

I am calling an oracle stored procedure through JDBC in a java application. This stored procedure returns a resultset as an out parameter, while getting the resultset parameter, jdbc is taking too much time about 5 to 6 mins. Here is the sample code i am using:

cstmt = conn.prepareCall(call);
 
cstmt.registerOutParameter(1, OracleTypes.CURSOR);
cstmt.setString(2, value);
cstmt.execute();
                        //this statement takes too long
rs = (ResultSet) cstmt.getObject(1);
 
  

Can anybody help??

Thanks

[Anonymous]

What are you dealing with then within the Stored Procedure call?