Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

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

by perldigious (Priest)
on Jan 30, 2020 at 14:44 UTC ( #11112094=note: print w/replies, xml ) Need Help??

in reply to Re: DBD::Oracle::st fetchrow_hashref failed: ORA-25401
in thread RESOLVED - DBD::Oracle::st fetchrow_hashref failed: ORA-25401

Generally stuff like this is a bit outside my depth, but I'll try to follow along. Apologies if I have to ask you to explain things to me like I'm a five year old.

It's odd, searching for the proper Makefile.PL to edit and going in to "C:\Strawberry\cpan\build" of my install I show 12 different "DBD-Oracle-1.80" directories just progressively numbered all last modified a couple days ago when I was trying to get that module installed and working for me properly.

I tried deleting them all but the original "DBD-Oracle-1.80-0" one and updating the Makefile in it as you suggested, but it didn't seem to help. I also tried deleting them all and reinstalling form CPAN but got the same result.

I did have to mess around with my system PATH variable after installing a suitable version of Oracle Client, I mostly followed afoken's guide here. Currently my system PATH variable has "C:\Strawberry\Perl\bin" at the top followed by "%ORACLE_HOME%\bin". If I recall, one issue I had is that when those were flipped my system kept loading an earlier version of Perl out of the Oracle directory instead of the Strawberry\Perl directory.

Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.
  • Comment on Re^2: DBD::Oracle::st fetchrow_hashref failed: ORA-25401

Replies are listed 'Best First'.
Re^3: DBD::Oracle::st fetchrow_hashref failed: ORA-25401
by choroba (Archbishop) on Jan 30, 2020 at 14:51 UTC
    > 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]>

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

      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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11112094]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2020-06-02 18:16 GMT
Find Nodes?
    Voting Booth?
    Do you really want to know if there is extraterrestrial life?

    Results (19 votes). Check out past polls.