Yes. I notice that but the DBD::Oracle 1.12 is the most recent module I can find from ActiveState. Does that mean this module is not working with Oracle 8i for fetching blob value?
David -----Original Message----- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 3:35 PM To: David Kuo Cc: [EMAIL PROTECTED] Subject: Re: Select BLOB field 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.
