total selected record count in cursor

Question

Hi,

My java program will call a PL/SQL(via jdbc) which will return result in cursor ( ref cursor type ). I would like to know is there any system variable or attribute that will keeps the total record in the cursor, without doing any looping of the cursor in the java program. Thanks.

Answer 1

One way to get the total number is to do a select count() on the query - I don't believe you can get this information via JDBC.