Did you compile your DBD::Oracle with OCI 8 if not you need to recompile or
use blob_read or readblob technique. See reame.longs in the DBD::Oracle
package.
Ilya Sterin
-----Original Message-----
From: Manish Grewal
To: [EMAIL PROTECTED]
Sent: 02/22/2001 9:36 AM
Subject: Reading from LONG RAW
Hi,
I'm getting the following DBI error from a select query
the query is : select f1, f2 from t1 where f0=$id;
f1 is type varchar(2) and f2 is type LONGRAW
Error is:
Could not prepare sql statement.
Error No 01406: fetched column value was truncated
(DBD: ofetch error on field 2 (of 2), ora_type 24,
LongReadLen too small and/or LongTruncOk not set.
while i've set the value of $dbh->{LongReadLen} = 99,999,999 (approx
100Mb).
and $dbh->{LongTrunkOk} = 1
Size of the data i want to fetch is around 900,000 bytes ( approx 900
Kb)
When i set LongTrunkOk=1, I just get truncated data around 38k with no
error.
my database is
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Also, does binary data require special handling in perl?
any pointers? ( i've confirmed that data is inserted correctly, i.e
whole
900kb of it)
