Here's the Setup:
Here's the problem:
I've seemingly finally gotten my scripts to mod_perl and am attempting to keep open a $dbh to share and improve performance. This is done using the guidelines laid out in http://perl.apache.org/guide/performance.html#Eliminating_SQL_Statement_Parsin
. I am not using the Apache::DBI module. AFAIK, the code in the URL above instructs me to keep a global $dbh in a package, and when I try to connect, first ping the dbh to see if it's still valid. If so, return that instance. If not, try to reconnect.
When I run this code from the shell, everything is fine. The DB is accessed without problems. However, when I invoke this via an HTTP request, I receive the following:
ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute/Describe)
I've tried to set all environmental variables I can think of in the CGI itself, but to no avail. Can someone _please_ tell me what else I could look at to track this down? I've Google'd the error and it seems to be a catchall kind of thing. All advice greatly appreciated. I would give more points if possible :)