On 26/01/11 01:21, William Ward gmail wrote: > In regards to this thread: > http://www.mail-archive.com/dbi-users@perl.org/msg32115.html > (found via google) > > I'm having the same problem at $JOB and before we throw ora_envhp=>0 > into our connect attribute, we were wondering if this will cause > performance issues? Is there a downside to ora_envhp that isn't > described in the thread? > > Or, is there some way to verify the OCI environment and reset it when > it is found to be unusable - in other words, trap the > "OCIHandleAlloc(OCI_HTYPE_ERROR)" error and reconnect? >
I think DBD::Oracle could perhaps trap the error to allocate a connection when the environment is dead and reallocate the environment. May be John Scoles has a comment on this and if so it could be rt'ed. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
