Thx.

Let me explain a bit more.
My stored procedure consists of 2 parts.

The first part retrieves a number according to some conditions and stores into a variable v_count. So I have coded


select count(*)
into v_count
from table_A
where [conditions1];


Afterwards, I've to open a cursor with this variable involved and return this cursor as the return type.

Open cursor for
select v_count as count, .....
from table_B
where [conditions2];


So the thing is, after I closed the JDBC connection, I supposed all the opened cursor should have been closed but an un-closed cursor is left in the DB with SQL-TEXT

select count(*)
from table_A
where [conditions1];


I hope it helps to explain my situation and is it so odd that such an implicit cursor still exist with closing!!!