We had this same exact problem. Same as you we were also doing $sth->finish() on each statement handle and we also even tried "undef $sth" after the finish(). None of these things worked. In our case we were using "$dbh->{RaiseError} = 1;" to do our error handling. It turned out that if we turned off RaiseError the problem went away. Of course, this meant that we had to do real error handling, but it's better that way anyway.
If your using RaiseError this may be your problem.
BTW: This is a very useful Oracle query to have in your mod_perl/Oracle application to check on your DBI::Oracle connection. Keep in mind that it's results are httpd child (Oracle connection) specific:
SELECT
sn.name,
my.value
FROM
v$mystat my,
v$statname sn
WHERE my.statistic# = sn.statistic#
Since we turned off RaiseError, we haven't seen a single cursor being left up. I'd love to know if this is a bug or that we were simply doing something wrong.
-Robert Jenks <[EMAIL PROTECTED]>
-----Original Message-----
From: Suresh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 3:00 PM
To: [EMAIL PROTECTED]
Subject: Apache::DBI and Oracle problem
Hi all,
I am currently developing a web application with Apache/Mod_perl running on redhat linux 6.1 and
connecting to Oracle Database, everything works fine, i started using persistant connection using
Apache::DBI, and after every request the open cursor count seems to always increase ( i am doing
finish for all the curosrs in my code ) and i hit the
ORA-01000: maximum open cursors exceeded
error after 1 or 2 hours.
i was trying to fix it but in vain.
suresh
__________________________________________________
Do You Yahoo!?
Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
