Can I get more information on open cursors?

From: Prem <psaldanha_at_exansoftware.com>
Date: 8 Nov 2001 20:38:04 -0800
Message-ID: <db0bd4fe.0111082038.3fbfb1ea_at_posting.google.com>

Looking for some information on open cursors. Is it possible to get a detailed description on the sql statement that is resulting in an open cursor being left behind. This would be really helpful in tracking down the missing one.

Right now, we are losing a cursor in our program (about 1 every 250 records), but cannot locate the 'offender'. If it is possible to get a listing of the SQL statement that causes this problem it would be much easier to track down.

Any help would be greatly appreciated.

Thanks
Prem Received on Fri Nov 09 2001 - 05:38:04 CET

This message: [ Message body ]
Next message: Vince: "Overloading procedures"
Previous message: Fernando: "DBLink Oracle SQL server"
Next in thread: andrija: "Re: Can I get more information on open cursors?"
Reply: andrija: "Re: Can I get more information on open cursors?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message