Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Ged Haywood
Hi there, On Tue, 12 Jun 2001, Mark Vandenbroeck wrote: There seems to be some confusion and even incorrectness in this trail. Let's get some things straight : Thanks for setting me straight! 73, Ged.

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Mark Vandenbroeck
Hi all, ORA-3113 means that the client process (DBD in this case) lost it's connection with the server process. This can be caused by network problems, but most often it's because the server process crashed unexpectedly. In that case, it always leaves a tracefile behind (in user_dump_dest),

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Eric Kolve
Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. BTW, I am also using the latest oracle client libs (8.17) if this makes any difference; as well, I am using perl 5.005. --eric Ged Haywood wrote: Hi there, On Mon, 11 Jun 2001, Eric Kolve wrote: I recently upgraded to DBI 1.18

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Ged Haywood
Hi again, On Tue, 12 Jun 2001, Eric Kolve wrote: Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. I seemed to get on better by removing NLS_LANG and ORA_NLS33 from my environment altogether. BTW, I am also using the latest oracle client libs (8.17) if this makes any difference;

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Mark Vandenbroeck
Hi all, There seems to be some confusion and even incorrectness in this trail. Let's get some things straight : * There is nothing wrong with NLS_LANG. In fact, it is extremely useful in an international setting. Your value is fine. * ORA_NLS33 is obsolete in 8.1.7 and should not be

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Ged Haywood
Hi there, On Mon, 11 Jun 2001, Eric Kolve wrote: I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at

Apache::DBI / DBD::Oracle error

2001-06-11 Thread Eric Kolve
I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153. I am