David Kuo [EMAIL PROTECTED] wrote:
> Hi there,
>
> To make it sure. My oracle client is on win2k OS and Oracle server is 8i on
> Solaris OS.
> Perl: ActivePerl 5.6
> DBI version : 1.35
> DBD::Oracle version is 1.12
>
> I have tried to fetch a BLOD field from Oracle and got a error below
> returned. The query is as simple as "select file_content from file_table
> where file_name = FileWanted". The data type of file_content is BLOB.
> >
> 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)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
It's been a while since I've worked with Oracle and DBD::Oracle,
but according to the error message, is it possible you built
your DBD::Oracle with Oracle 7?
--
Hardy Merrill
Red Hat, Inc.
