Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread Bill Ward
I've never used Apache::DBI but looking at the documentation it appears pretty straightforward. We'll consider that, but at $JOB we are very slow to uptake any CPAN modules without a lot of review and ponderous thought. On Thu, Jan 27, 2011 at 3:42 PM, John Scoles wrote: > I would say simply co

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread John Scoles
I would say simply convert over to Apache::DBI you would not have to change any of your code except use DBI; to use Apache::DBI Will most likely solve any problems you are having cheers On Thu, Jan 27, 2011 at 4:26 PM, Bill Ward wrote: > > > On Thu, Jan 27, 2011 at 4:04 AM, John Scoles wr

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread Bill Ward
On Thu, Jan 27, 2011 at 4:04 AM, John Scoles wrote: > On 26/01/2011 3:35 PM, Bill Ward wrote: > >> On Wed, Jan 26, 2011 at 12:27 PM, John Scoles wrote: >> >>> 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 "O

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread John Scoles
On 26/01/2011 3:35 PM, Bill Ward wrote: On Wed, Jan 26, 2011 at 12:27 PM, John Scoles wrote: 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? Well normally an env