Re: Perl in 10.2.0.3

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 2 May 2008 08:41:45 -0500 (CDT)
Message-ID: <44374.12.17.117.251.1209735705.squirrel@12.17.117.251>

The log checker I wrote is in Perl, using the version that comes with Oracle. In my case, it's 10.1.0.5.0 on AIX, which happens to be 64-bit. For DBI/DBD::Oracle, which is also thoughtfully included in the Oracle-supplied Perl, you could try something like this for a test:

#!/u01/app/oracle/product/10.1.0/db_1/perl/bin/perl -W

use DBI qw(:sql_types);
$dbh = DBI->connect("dbi:Oracle:","","", { ora_session_mode => 2 })||die "%ERROR opening DB: $DBI::errstr";
$sth = $dbh->prepare(qq{

        SELECT 1
        FROM dual

});
$sth->execute;
$sth->bind_columns( \($Dummy) );
while ($sth->fetch)
{

        print "$Dummy\n";
}
$sth->finish;
$dbh->disconnect;

This li'l ditty uses OS authentication (e.g. "OPS$ORACLE") to login to $ORACLE_SID and run the simplest of queries. Note that you'll need to replace the path to the Perl executable with your own. You'll also probably need to define the environment variable PERL5LIB to something like:

PERL5LIB=/u01/app/oracle/product/10.1.0/db_1/perl/lib/5.6.1:/u01/app/oracle/product/10.1.0/db_1/perl/lib/site_perl/5.6.1

...again, substituting for your own $ORACLE_HOME.

Granted, there are some nice modules missing from the Oracle version of Perl, but it's an option to consider.

HTH! GL! Rich

p.s. Feel free to correct/critique any of my drivel, Jared! :)

> The real question is does PERL support 64-bit operating systems?

>

> We use PERL all the time on 64-bit systems with Oracle the only
> problematic part is trying to get Perl, DBI and DBD to compile on a 64bit
> system.

>

> Once it is up and running I have never run into any issues with 32bit vs
> 64 bit Oracle and PERL.

>

> cheers

>
>
>> Hi,
>>
>> Kindly clarify me on the below think
>>
>> We have Development users who uses PERL for there development work in
>> oracle 9.2.0.8 32 bit version. In the past they had trouble compiling
>> PERL on ORACLE 10g 64-bit, So we have not upgraded the database to 10g
>> version.  Do oracle 10.2.0.3 supports PERL?
>>
>>
>> Thanks and Regards,
>> Dhandapani S

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 02 2008 - 08:41:45 CDT