No, it has to do with the version of the OCI libraries that DBD::Oracle was linked with. In fact, if you link with the 9.x libraries, you can't access a 7.x server, or if you linked with 7.x libraries, you can't access a version 9.x server. I do not have an 8.x server (or it's client libraries), but check the oracle installation on the machine that you are using DBD::Oracle from.
Rafael On Tue, 2003-06-24 at 14:54, David Kuo wrote: > 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. >
