On Fri, Aug 10, 2001 at 12:52:48PM -0400, Robert Landrum wrote:
The show continues...
> alter session set COMPATIBILITY = '8.1.6';
>
> when you first create your database handle.
I've rebuilt DBD::Oracle with "-8" key, as it was suggested by README;
I've added 'alter session' to each connection open;
I'm getting:
DBD::Oracle::db prepare failed: ORA-03120: two-task conversion routine:
integer
overflow (DBD: error possibly near <*> indicator at char 1 in '<*>select
slogan_
text from slogans where SHOW_ON_MAINPAGE='Y'') at /usr/local/www/lib/SQL.pm
line
221.
SQLMethods-/usr/local/www/lib/SQLMethods.pm-56select slogan_text from
slogans wh
ere SHOW_ON_MAINPAGE='Y'DBD::Oracle::db prepare failed: ORA-03113:
end-of-file o
n communication channel (DBD: oopen error) at
/usr/local/www/lib/SQLMethods.pm l
ine 102.
and EVERY connect to database fails since that.
I was NOT able to reproduce this bug outside of mod_perl.
Alex.
