Unclosed Implicit cursor
I've some problem when calling a stored procedure through JDBC.
The stored procedure is written like this;
open v_cur for
select v_count, .....
After calling the procedure and closed the corresponding callablestatement object through JDBC, it is found that an unclosed cursor is left in DB:
select count(*) from table_A
How come the implicit cursor never closed, am I doing something wrong? Please advise. Thx.
Click Here to Expand Forum to Full Width