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


in reply to DBD::Oracle::st fetchrow_hashref failed: ORA-24345

What version of DBD::Oracle? There seems to be an old patch for this issue here, and the latest version of the code seems to cover that issue (though the code is a bit different), so I'm wondering if you have a (very) old version.

And just curious if the following would fix the problem:

$sth->execute(...);
my $serial_num = '0' x 50_000; # Or more?
$sth->bind_col(1, \$serial_num);
while ($sth->fetch()) {
  print "$serial_num\n";
}

[download]

Replies are listed 'Best First'.
Re^2: DBD::Oracle::st fetchrow_hashref failed: ORA-24345
by gopalr (Priest) on Sep 06, 2013 at 16:47 UTC

    The version is 1.15

[reply]
      I would try the latest version, or first try the code I posted above (though I have no idea if either will work).
[reply]

In Section Seekers of Perl Wisdom