Maximum open cursors BDE + Oracle


2003-08-07 05:31:10 PM
delphi28
Hi all,
I am having the following problem with the BDE:
I use a TQuery-component to delete a record: DELETE FROM ATABLE WHERE SEQ =
:SEQ
The record is deleted, but in Oracle 8.1.7 (and Oracle 9.2) the cursor stays
sometimes open.
When I try to delete thousands of records I get the error message:
ORA-maximum open cursors exceeded.
I believe this is a bug in the BDE.
Does anyone have a workaround for this or how can I tell the BDE to close
any open queries?
PS: For most of our projects we use ASTA and do not have this problem, but
for this project I have to stay to BDE.
Kind regards,
Aad