This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: Select on CLOB fields in Oracle From: Tim Bunce <Tim.Bunce@ig.co.uk> Date: Wed, 12 Jul 2000 09:51:10 +0100 On Wed, Jul 12, 2000 at 02:29:03PM +1000, Kinetic wrote: > > Hi, I'm having a problem doing a SELECT from a CLOB field in an Oracle > DB. > > DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes (DBD: > oexfet error) at ./dbgrab.pl line 17. > > I've been reading that the DBI only returns a reference.. or a pointer > to the CLOB field when you try to do a select on a clob field, and that > sqlplus will do an automatic dereference for you when you do a select.. > how do you do a select on a clob field in the DBI? A DBD::Oracle built using Oracle 7 can't fetch Oracle 8 LOB values. To help me improve the error message in this case, please send me a trace file (add DBI->trace(4,"dbitrace.log"); near the top of your code. Someone else may know if there's a way to convert a LOB to a LONG or VARCHAR using an SQL function. Tim. ===