Problem with DBD:Oracle and bind variables

From: Dan Maloney (daniel.maloney_at_bms.com)
Date: 04/08/04 

Date: 8 Apr 2004 12:51:02 -0700

Setup: Perl 5.005, DBI 1.21, DBD:Oracle 1.03 (from the 1.03-2 RPM, by
the way), talking to Oracle 8i on a different machine. The code has
been stable for years, but suddenly, I'm finding that DBI is choking
when I try to do any SELECT with bind variables in the WHERE clause. I
can connect fine, but the code sticks when it gets to the first SELECT
with bindings. After 10 minutes or so, it times out and displays:

DBD::Oracle::db selectall_arrayref failed: Error while trying to
retrieve text for error ORA-03113 (DBD ERROR: OCIStmtExecute) at
bin/test_db_with_bindings.pl line 25.

And it dumps core. If I replace the bindings with hardcoded values,
the SELECT works fine.

I know that the machine hosting the Oracle instance had "issues" just
before the problem surfaced, and there's a possibility the DBA
squashed some files or something. We have an identical instance on
another machine that didn't have the same issue, and I can get the
code to run successfully if I point to that instance, so I know the
Perl works. Any ideas?

Relevant Pages