LiveHTML - problem reading from (c)lob field - ORA-00932

From: Markus Langlotz <mlanglotz_at_medienagentur.de>
Date: Fri, 22 Oct 1999 12:38:58 +0200
Message-ID: <7uper0$7ua$1@black.news.nacamar.net>

Hi all,

I've got a problem selecting data from blob fields using LiveHTML and Perl. As far as I have read (README.longs in DBD::Oracle) , one can use something like this:

$logon = DBI->connect(....)
$logon->{RaiseError) = 1;
$logon->{LongTruncOk} = 1;

....

to prepare the reading of lob or long fields.

I only get the following error message when trying to execute the query, so I can
not even try to fetch blob fragments using $logon->blob_read as seen in README.longs:

---

LiveHTML script execution error[1]:
ORA-00932: nicht uebereinstimmende Datentypen (DBD: oexfet error) at (eval 246) line 13.
(not corresponding datatypes...)

---

maybe I could get results using the dbms_lob package or are there any other possibilities using
LiveHTML and DBI/DBD::Oracle?

Thanks in advance for any help or hint.

Markus

--
Markus Langlotz
+++ OOD/OOA, Entwicklung, Programmierung, Datenbanken +++ Kresse & Discher GmbH Medienagentur
In der Spöck 2
77656 Offenburg, Germany
Phone 1: ++49 (0)781/95 50 0 Phone 2: ++49 (0)781/95 50 35 Fax: ++49 (0)781/95 50 50
Mail: mlanglotz@medienagentur.de WWW: http://www.medienagentur.de Received on Fri Oct 22 1999 - 05:38:58 CDT