> 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>
