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


Reply via email to