Maximum open cursors + BDE + Oracle

Article View: borland.public.delphi.database

Article #103

Back to borland.public.delphi.database Previous Next

#103

From: Aad Aldus
Date: Thu, 07 Aug 2003 09:32

23 lines
1529 bytes

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

Technical Details

Message-ID: <3f321c93$0$49103$e4fe514c@news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!transit.news.xs4all.nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,b9f7eae32e862c28,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-08-07 02:32:14 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!transit.news.xs4all.nl!not-for-mail
From: "Aad Aldus" <a.aldus@modality.nl>
Newsgroups: borland.public.delphi.database
Subject: Maximum open cursors + BDE + Oracle
Date: Thu, 7 Aug 2003 11:32:42 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 25
Message-ID: <3f321c93$0$49103$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 07 Aug 2003 11:32:03 CEST
NNTP-Posting-Host: 194.109.254.208
X-Trace: 1060248723 news.xs4all.nl 49103 194.109.254.208:63185
X-Complaints-To: abuse@xs4all.nl