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)
