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

I am new to Perl. Is there an Oracle9i version of DBI & DBD? If so, where do I get it from? My database platform is Solaris 5.8 64-bit. Also, my workstation is Windows/2000. I will like to install the DBI & DBD for Oracle9i on my PC. Larry

Replies are listed 'Best First'.
Re: Using Oracle9i
by VSarkiss (Monsignor) on Nov 22, 2002 at 16:53 UTC

    The DBI and DBD::Oracle are both available on the CPAN from those links. In addition, you'll need the Oracle client for Windows 2000, either from your CDs or from the Oracle OTN site.

    Both DBI and DBD::Oracle come with good documentation that you can also get online. If you haven't used the DBI before, you may want to invest in the book Programming the Perl DBI. You can buy it printed or O'Reilly's Safari version.

    Of course, if you haven't already, you may want to look into getting a Perl book, like the Camel or the Llama, or any of the excellent collections.

    HTH

[reply]
Re: Using Oracle9i
by vek (Prior) on Nov 22, 2002 at 16:35 UTC
    The latest versions of DBI and DBD::Oracle will do the trick.

    Update: In my haste I can see that I did not read the entire question. I thought you were asking if there was an Oracle 9i version of DBI & DBD::Oracle for Solaris. I missed the point about using your Windows box as the client. Thankfully other monks did read your question fully and have offered some good suggestions.

    -- vek --
[reply]
      Remember that you need to install the Oracle client libraries in order to install DBD::Oracle.

      For use on windows there are some simpler ways of installing perl ie ActivePerl rather that going to the CPAN source. But be careful as these are often compiled against the Oracle 8i/7 libraries so you may need to install this version

      Hope it helps
      UnderMine

[reply]
      Vek, will DBD-Oracle-1.12 and DBI-1.30 work on both Solaris 5.8 and Windows/2000? Larry
[reply]
        You do not need to install Perl, DBI or DBD::Oracle on your server unless you wish to run scripts on this server.

        Oracle clients talk to the server via a propritry set of protocols (TNS, Net8 etc) which sit on top of you normal network layer (ie TCP/IP).

        Hope this Helps
        UnderMine

[reply]
        DBI 1.30 and DBD::Oracle 1.12 will work on Solaris 5.8. Not 100% sure about Win2k.

        -- vek --
[reply]
Re: Using Oracle9i
by rdfield (Priest) on Nov 22, 2002 at 16:53 UTC
    If you're using Activestate's Windows distro then install DBI and DBD::Oracle using PPM, 
    ...start->run->"ppm"
PPM>install DBI
PPM>install DBD::Oracle
PPM>exit

    [download]

    rdfield

[reply]
[d/l]

Back to Seekers of Perl Wisdom