Hi experts,

I've some problem when calling a stored procedure through JDBC.

The stored procedure is written like this;

v_count varchar2(12);
IS
select count(*)
into v_count
from table_A;

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.