That is what I need to know! It is working after I install Oracle8 modules. Thanks guys!
David -----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:10 PM To: [EMAIL PROTECTED]; 'Hardy Merrill' Cc: [EMAIL PROTECTED] Subject: RE: Select BLOB field > > > 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. > >
