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) > I have tried to set the LongReadLen and LongTruncOk options but with no luck. It still got the same error. Can anyone please help how to make it work or it just could not be done by given configuration? Thanks in advance! David
