> > > 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?
Use PPM to install DBD-Oracle8 Jeff > > 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. > >