RE: Problem in fetching CLOB data using perl DBI

2002-07-12 Thread TomST
Paresh Kakrecha [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: Problem in fetching CLOB data using perl DBI Hi , I have perl script to fetch CLOB data from oracle table Table structure is ID number ( 5) long_field clob Perl code : #!/usr/

Problem in fetching CLOB data using perl DBI

2002-07-12 Thread Paresh Kakrecha
Hi , I have perl script to fetch CLOB data from oracle table Table structure is ID number ( 5) long_field clob Perl code : #!/usr/local/bin/perl5 use DBI qw(:sql_types); $dbh= DBI->connect ( . ); $dbh->{LongReadLen}=512*1024; $sql="select * from table"; $sth = $dbh->prep