Selecting a LOB using DBI & DBD:Oracle

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Mon, 3 Jul 2000 10:31:47 +0200
Message-Id: <10547.111084@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_020B_01BFE4D9.E44B00A0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi , gurus !
Would U please help mew with the following : I need to extract a CLOB/BLOB column from a table and put the LOB = contents into a file .
I'm trying to select a CLOB/BLOB column and receiving the following = error :

DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes (DBD: = oexfet error) at D:\work\UPLOAD\ValidURLs.pl line 142.

What might be the possible reasons for this error ?

I'm using ActivePerl5.6 , Oracle 8.1.6 on windows2000 . =20
Thanks a lot in advance=20
=20

Andrey=20
VisualTop.com

=20

------=_NextPart_000_020B_01BFE4D9.E44B00A0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV style=3D"FONT: 10pt arial"></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Hi , gurus !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Would U please help mew with the =
following=20
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I need to extract a CLOB/BLOB column =
from a table=20
and put the LOB contents into a file .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to select a CLOB/BLOB column =
and=20
receiving the following error :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DBD::Oracle::st execute failed: =
ORA-00932:=20
inconsistent datatypes (DBD: oexfet error) at = D:\work\UPLOAD\ValidURLs.pl line=20
142.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What might be the possible reasons for =
this error=20
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm using ActivePerl5.6 , Oracle 8.1.6 =
on=20
windows2000 .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot in advance </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey =
<BR>VisualTop.com<BR></DIV></FONT>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR></FONT> </DIV></BODY></HTML>
Received on Mon Jul 03 2000 - 03:31:47 CDT