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.
Here is what is happening.
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?
解决方案
Perhaps the stored proc could be changed to return a value indicating if the cursor is open. Something like the following might be useful:
TYPE tCursor IS REF CURSOR;
PROCEDURE A_PROC(returned_cursor OUT tCursor,
bCursor_is_open OUT BOOLEAN,
aNother_value OUT NUMBER,
yet_another_value OUT NUMBER);
The procedure should set bCursor_is_open to TRUE if it opens the cursor, or FALSE if the cursor is not opened.