Dear all,

We have a number of scripts running that can work for both MySQl and Oracle
databases.
The scripts does a lot of DB-access (select, update, insert). The number of
accesses depends on the size of the folder we are processing. The larger the
folder, the more accesses we get.

While running on a Oracle8i DB, we get following strange problem:
When processing a small folder all goes well,
but when processing a large folder the scripts die on a '$sth->prepare()' or
'$sth->execute()' and we can never predict on which one or why. We use the
same $dbh for all these db-accesses.

Does anyone have any ideas on this problem ?
Is there a limitation on the number of accesses (in Oracle) ?
Does the DBI-module (1.20) or the Oracle-module (1.12) leak memory ?
Is there a simple way to check what exactly when wrong ? ($dbh->errstr
doesn't help...)

Any help or starting point of where to look for the problem would really
help !

Regards,
Koen Gogne


Reply via email to