You must recompile DBD::Oracle with OCI8 libs, if not already done. You can
then set LongReadLen to any number you want.
To set LongReadLen and LongTruncOk see perldoc DBI.
The only time you need to set LongTruncOk is if you want your data truncated
past LongReadLen number, otherwise set LongReadLen to the longest possible
number for that column.
Ilya
> -----Original Message-----
> From: venkat satya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 4:11 PM
> To: [EMAIL PROTECTED]
> Subject: blob in DBI
>
>
> Hi,
> I have oracle 8.1.7 DB/perl 5.6 . I need to read a blob
> content column
> into perl ( using DBI/DBD). While reading i get an error stating
> "LOB value truncated from 2562677 to 80. DBI attribute
> LongReadLen too small
> and/or LongTruncOK not set". How can i set these
> values. ( I presume even then the max size is 64KB). Such case how can i
> read a blob from DB.( I read somewhere that it's possible by
> suign OCI8). If so, how to use it?. Can someone help me ?.
> Thanks in advance.
>
> kumar
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
