Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem
[email protected] ("Martin J. Evans")
| Newsgroups | perl.dbi.users |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
On 26/01/11 01:21, William Ward gmail wrote: > In regards to this thread: > http://www.mail-archive.com/[email protected]/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