This code fragment:
my $sql=q{select * from v$version};
my $sth = $dbh->prepare($sql,{ora_check_sql => 0 });
$sth->execute;
print qq{
DBI Version: $DBI::VERSION
DBD::Oracle Version: $DBD::Oracle::VERSION
--------------------------------------------
SQL: select * from v\$version;
};
while( my $ary = $sth->fetchrow_arrayref ) {
print join(' ',@{$ary}),"\n";
}
produces this output:
DBI Version: 1.38
DBD::Oracle Version: 1.14
--------------------------------------------
SQL: select * from v$version;
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
This on RH 8.0
HTH
Jared
On Fri, 2003-12-19 at 02:22, Scheper, Clemens wrote:
> Hello,
>
> does DBD-Oracle-1.14 support ORACLE9i (9.2.0.4)?
>
> Connecting to ORACLE9 with DBD-Oracle-1.12 I get error message
>
> DBI->connect(DWHT) failed: ERROR OCIEnvInit at ... line ...
>
>
> Regards, Clemens Scheper
> --
>
>
>
