stry_cat has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

This is on a Win2k box with Oracle 9i and ActiveState Perl 5.6. DBI and DBD::Oracle were installed from CPAN.

I keep getting an error:

The procedure entry point kpuhhmrk could not be located in the dynamic link library oraclient8.dll
The only useful thing a google search turned up was needing to have ORACLE_HOME set correctly. I think it is set correctly (F:\Oracle\Ora92\). I also don't understand why it's looking for oraclient8.dll when the oracle version is 9.

Has anyone had any experience with this type of problem? Does anyone know how to fix this?

Thanks,

Tom

20040819 Edit by broquaint: Changed title from 'kpuhhmrk?!?'

  • Comment on DBI/DBD Oracle setup problem -- missing entry point?!?

Replies are listed 'Best First'.
Re: DBI/DBD Oracle setup problem -- missing entry point?!?
by dragonchild (Archbishop) on Aug 18, 2004 at 19:30 UTC
    When did you install DBI/DBD::Oracle? What versions are they? What version of Oracle was installed when you installed them?

    ------
    We are the carpenters and bricklayers of the Information Age.

    Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

    I shouldn't have to say this, but any code, unless otherwise stated, is untested

[reply]
      Oracle has been running on the box for a while (I'm not the DB guy so I'm not sure exactly when it was installed, but 9i should be the only version ever on that box). I downloaded and installed Perl from ActiveState on Friday. I chose 5.6 over 5.8 b/c it has some modules precompiled that 5.8 didn't. I downloaded and installed DBI and DBD::Oracle from CPAN Monday. 
      perl -e use DBI; use DBD::Oracle; print DBI->VERSION; print "\n"; prin
+t DBD::Oracle->VERSION;'

      [download]
      outputs

      1.37
      1.06

[reply]
[d/l]
        That's pretty funny, seeing as DBI is at 1.43 and DBD::Oracle is at 1.15. I would strongly recommend upgrading (if you can find a pre-compiled version somewhere). That may be your issue. I'm not completely positive, but I don't think 1.06 had full Oracle9i support. I haven't used 9i with anything lower than 1.12 (or so).

        Just to give you an idea, according the DBD::Oracle Changes file, 1.06 was released on July 14, 2000. 9.0.1.0 was released sometime in 2002.

        ------
        We are the carpenters and bricklayers of the Information Age.

        Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

        I shouldn't have to say this, but any code, unless otherwise stated, is untested

[reply]

Back to Seekers of Perl Wisdom