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