-Original Message-
> From: Xiaoping Gu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 1:23 PM
> Cc: Michael A. Chase; Sterin, Ilya; 'Dan, Ephraim '; [EMAIL PROTECTED]
> Subject: Run out of number of cursor using DBD::Oracle when
> inserting/updating
>
> Hi,
to update 3 different rows in the same table. I suspect you
> are creating cursors and not reusing them.
>
> -Original Message-----
> From: Xiaoping Gu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 1:23 PM
> Cc: Michael A. Chase; Sterin, Ilya; 'Dan, Ephraim ';
Gu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 1:37 PM
To: Wilson, Doug
Cc: '[EMAIL PROTECTED]'; Michael A. Chase; Sterin, Ilya; 'Dan, Ephraim ';
[EMAIL PROTECTED]
Subject: Re: Run out of number of cursor using DBD::Oracle when
inserting/updating
Below is one piec
EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 1:23 PM
Cc: Michael A. Chase; Sterin, Ilya; 'Dan, Ephraim '; [EMAIL PROTECTED]
Subject: Run out of number of cursor using DBD::Oracle when
inserting/updating
Hi,
We have a perl program to insert/update/select to Oracle database
using DBI
Hi,
We have a perl program to insert/update/select to Oracle database
using DBI and DBD::Oracle. After each execute, we commit it.
However, it only inserts/updates about 100 rows then runs out of
number of cursors. The open_cursor is set to 100. However, why
the cursors are not released after
