http://www.perlmonks.org?node_id=760909


in reply to Re^2: DBD::Oracle - OCILobRead error
in thread DBD::Oracle - OCILobRead error

Just set it to an arbitrarily large value:
$dbh->{LongReadLen} = 1024*1024; # or even another 1024*4