Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SQL Stored Procedures - Close cursors that were left open

In a rare situation involving a complex set of stored procedures, cursors could leak. In c-tree stored procedures, cursors need to be closed explicitly; if this is not done, the cursor is leaked.

Logic has been added to the function that starts stored procedures to identify cursors that are opened and not closed within a stored procedure and close any that are found. When Java debugging is turned on in TPESQLDBG, a message is logged in sqlserver.log to help in identifying the stored procedure and the statement that leaked the cursors.

TOCIndex