Re^3: DBD::Oracle::st fetchrow_hashref failed: ORA-25401

> cpan
...
cpan[1]> get DBD::Oracle
...
cpan[2]> look DBD::Oracle
... # Fix the Makefile.PL
> perl Makefile.PL
> make  # or your variant whereof
> make install
> exit
cpan[3]>
[download]

map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]

Comment on Re^3: DBD::Oracle::st fetchrow_hashref failed: ORA-25401 Select or Download Code

Replies are listed 'Best First'.
Re^4: DBD::Oracle::st fetchrow_hashref failed: ORA-25401 by perldigious (Priest) on Jan 30, 2020 at 15:08 UTC
Awesome, that worked and it installed successfully. Thanks, choroba. The bad news is that didn't fix my original issue. :-/ I'm still seeing the "fetchrow_hashref" fail... typically it either hangs forever on the same row, or it gets passed that row, hangs for a short time on another culprit row and then gives the error in the title of this thread before successfully running another query on another table and the script finishing... If it's something in the actual data for those rows that's causing it to fail it's odd that sometimes it fails on the earlier row and sometimes not. I am able to run the same query from a SQL Developer environment without issue. Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.	[reply]

Replies are listed 'Best First'.

Re^4: DBD::Oracle::st fetchrow_hashref failed: ORA-25401
by perldigious (Priest) on Jan 30, 2020 at 15:08 UTC

Awesome, that worked and it installed successfully. Thanks, choroba.

The bad news is that didn't fix my original issue. :-/

I'm still seeing the "fetchrow_hashref" fail... typically it either hangs forever on the same row, or it gets passed that row, hangs for a short time on another culprit row and then gives the error in the title of this thread before successfully running another query on another table and the script finishing...

If it's something in the actual data for those rows that's causing it to fail it's odd that sometimes it fails on the earlier row and sometimes not. I am able to run the same query from a SQL Developer environment without issue.

Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.

[reply]