Hi All,

Can rs.last() work for stored procedure calls. Please find the code and
the error below.

CallableStatement cstmt = dbconnection.prepareCall("" + "{call
CallProcedureNames()}", ResultSet.TYPE_FORWARD_ONLY
,ResultSet.CONCUR_READ_ONLY);

ResultSet rs = cstmt.executeQuery();

rs.last();  //This is the place it errors out....

Error Message:

Caught exception: java.sql.SQLException: Fetch type is
TYPE_FORWARD_ONLY

Please note the above code works fine if I fire a query... but doesn't
work for a stored procedure.

I am in a great need please help me.