title: Is there a way to find out a database cursor is open or not in Java?
body: <p>Is there a way in JDBC to find out the cursor opened or not in JAVA.
  We are getting an exception when tried to access an un opened cursor.
  java.sql.SQLException: Cursor is closed.</p>
  
  <p>Here is what is happening.</p>
  
  <p>The Stored proc is designed this way. the proc returns the cursor and a couple of other columns. For some conditions, the DB guy is not opening the cursor and returns only the other remaining column outside of the cursor. So when the Java code tries to get cursor, it throws this exception. I know, I can catch the exception and proceed further with the remaining columns. But I was wondering is there a different (may be better) way to handle this? 
  Or just need to open the cursor in the stored proc, even if there is nothing to return as part of the cursor?</p>