----- Original Message -----
From: "venkat satya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 4:11 PM
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.
Did you read PODs of DBI ,DBI::FAQ and DBD::Oracle ?
How about doing these commands at your command line?
> perldoc DBI
> perldoc DBI::FAQ
> perldoc DBD::Oracle

cf.
DBI::FAQ
5.2 How do I handle BLOB data with DBI?
  http://dbi.perl.org/doc/faq.html

==============================================
Kawai, Takanori(Hippo2000)
   Mail: [EMAIL PROTECTED] [EMAIL PROTECTED]
   http://member.nifty.ne.jp/hippo2000
==============================================

Reply via email to