Re: access Oracle from Perl

I know that I'm using Linux (RH 8.0) and I don't have any problems with 5.8 or DBD/DBI. Here is what I have: $ ./drivers.pl
Driver: ExampleP
Data Source: dbi:ExampleP:dir=.

Driver: Oracle
Data Source: dbi:Oracle:ADM.ADELPHIA.NET Data Source: dbi:Oracle:LOCAL.ADELPHIA.NET

Driver: Proxy
install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28. BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28. Compilation failed in require at (eval 3) line 3. Perhaps a module that DBD::Proxy requires hasn't been fully installed  at ./drivers.pl line 7
$

Here is the drivers.pl that generated the output above: #!/usr/bin/perl
use DBI;
my @drivers=DBI->available_drivers();
die "No drivers found.\n" unless @drivers; foreach my $driver ( @drivers ) {

    print "Driver: $driver \n";
    my @datasources = DBI->data_sources( $driver );     foreach my $datasource ( @datasources ) {

        print "Data Source: $datasource \n";     }
    print "\n";
}
exit;

As you can see, Perl 5.8 works perfectly with DBI and DBD::Oracle on Linux. My advice is to switch to RH 8.0 (avoid 9 at all costs).

On 2003.05.26 04:26 Denham Eva wrote:
> Jared,
>
> Does that mean that you don't use Perl on Windows, or don't use windows at
> all?
> If you do, can you give us an idea of what your set up is, please.
>
> Regards
> Denham
>
> -----
>
> Mladen,
>
> It ain't that simple. The DBD::Oracle for Perl 5.8 needs to be compiled
> with 5.8 libs.
>
> ActiveState is letting it go by the wayside. They do not have a
> DBD::Oracle that
> is installable with 5.8.
>
> Even installing on 5.6.1 is a hack, you can't just load it from PPM
> anymore.
>
> There was one at xmlproj.com, but the owner of that domain has gone
> incommunicado.
>
> Jared
>
> _____________________________________________________________________________________
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal
>
> For more information please visit www.marshalsoftware.com
> _____________________________________________________________________________________
>
> #####################################################################################
> Note:
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are not
> the intended recipient. THIS COMPANY NAME and any of its subsidiaries each reserve
> the right to monitor all e-mail communications through its networks.
>
> Any views expressed in this message are those of the individual sender, except where
> the message states otherwise and the sender is authorized to state them to be the
> views of any such entity.
>
> Thank You.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Denham Eva
> INET: EvaD_at_TFMC.co.za
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).