Any info on blob_read in dbi(if its there) would be welcome too
>Date: Thu, 22 Feb 2001 08:36:45 -0800
>To: [EMAIL PROTECTED]
>From: Manish Grewal <[EMAIL PROTECTED]>
>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)
