Hello Andy,
Thank you for your input. Sorry I forgot to put the version of my
DBD::Oracle and here it is
PPM> query DBD::Oracle
DBD-Oracle [1.12] Oracle database driver for the DBI module
However, I am not sure exactly how to recompile DBD-Oracle against
Oracle8i. The data that is in the blob is zipped/compressed XML data.
Also, please note that I am using Cygwin to run the Perl application.
Thank you for all your help and input.
NRK
"Andy Hassall" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>> I have a perl script that accesses a BLOB of data
>> from the DB.
>>
>> Below is the error I keep getting:
>> $ perl Test_Blob.pl
>> 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 Test_Blob.pl line 25.
>> 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 Test_Blob.pl line 25.
>
> As the error says, an Oracle 7 client cannot read CLOB or BLOB; those data
> types did not exist in Oracle 7. Your version of DBD::Oracle appears to
> have
> been compiled against an Oracle 7 client.
>
> Recompile DBD::Oracle against a more recent version of Oracle; 8.1.7, 9.2
> or 10.1. The sensible choice would be the version that matches your
> database
> server.
>
> Since you're trying to use BLOBs, it seems to follow that your database
> server is at least an 8.1.7 database, but you've not posted your versions
> or
> the definition of DT_PUBLIC_DATA so this too is an assumption.
>
> --
> Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool
> <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
>
