Problem in fetching CLOB data using perl DBI

[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->prepare($sql);

    $sth->execute();

    while ( ($id , $edi_data ) = $sth->fetchrow ) {

     print "id=$id\n";
     print "data=$edi_data\n";

   }

     When I try to fetch data I get error like

ORA-03115: unsupported network datatype or representation (DBD: odescr failed)

Can anyone suggest why I am geting this error and what is the resolution.

thanks
Paresh.