I'm using perl v5.6.1, DBI v1.27, DBD-Oracle v1.06, DBD-ODBC v0.28 to
connect to Oracle 8i v8.1.7.2.0 from a Windows 2000 Pro v5.0SP3 PC.
Everything has worked well for reporting purposes until I tried to select
from a CLOB field when I received this error:
DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes (DBD:
oexfet error, e.g., can't select LOB fields using DBD::Oracle built for
Oracle 7) at qh.pl line 36.
According to the documentation I have read, the DBD::Oracle module should
default to the Oracle 8 OCI API functions after version 0.55. Since I am
using version 1.06, I'm not sure why DBD appears to be using the Oracle 7
OCI API functions. I've verified through PPM that I have installed the most
recent versions of DBI, DBD-Oracle, and DBD-ODBC. I've set the
{LongReadLen} and {LongTruncOk} parameters as suggested in the Perl DBI
book. In fact, the query in question is closely based on an example in the
book. Any help would be appreciated.
Thanks,
pb
