cursors which opened in stored procs -- don't close

[Andrey Maximenko. Ukraine]

We are using Delphi7 + DOA 4.0.6.2.
Our soft consist of main-exe and a few dll.
After logoff dll-session and exit from dll to main-exe, cursors which opened in stored procs don't close.
We are looking cursors in V$open_cursor and V$SQL
Oracle 8.1.7
Thanx

 

[Andrey Maximenko. Ukraine]

This Procedure I called from dll:
-----------------------------
CREATE OR REPLACE PACKAGE BODY Test_Curs AS
PROCEDURE updatea1(p_id IN NUMBER, Param1 IN NUMBER)
IS BEGIN
UPDATE TEST_SURS2 SET a1=Param1 WHERE id=p_id;
END;
END Test_Curs;
------------------------
After exit from dll I can see
------------------------
UPDATE TEST_SURS2 SET A1=:b1 WHERE ID = :b2
------------------------
in V$open_cursor

 

[Marco Kalter]

Cursors that are closed on the client will not immediately be closed on the server. When you open a new cursor, the previously closed cursors will also be closed on the server. This is a network roundtrip optimization in Oracle Net.