-
Unclosed Implicit cursor
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.
Carlos
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|