JBDC refcursor problem with Oracle

[patnim17]

Hi,
I have a Stored Procedure that has one of the parameters as ref Cursor. When I call the stored procedure from Java using JDBC..I get the cursor into a resultset object like this:

rs = (ResultSet)objStmt.getObject(iCurPos);

where rs is a ResultSet, objStmt is a CallableStatement, and iCurPos is the ref cursor position in the stored procedure.

Now, the problem is when the cursor is not opened at all, which is very much possible, then I get a Invalid ref Cursor Error raised by Oracle..

How can I handle this situation, so that I have a Empty record Set in rs ( 0 records) in case of this situation?


pat

 

[sem]

You may handle this issue on Oracle side: istead of not opening a cursor you may open it for some dummy statement like <your original query .. and 1=0>. Another way is to catch that error and process it gracefully.

Regards, Dima

http://seminihin.narod.ru