Error:--- cmpilation failed in required at E:\perl\d.pl line 5#!/usr/local/bin/perl use strict; use DBI; # Connect to Oracle database, making sure AutoCommit is # turned off and potential errors are raised. my $dbh = DBI->connect( 'dbi:Oracle:orcl', 'scott', '**', { RaiseError => 1, AutoCommit => 0 } ); # Create the SQL. my $sql = qq{ SELECT 'Hello World' FROM DUAL }; # Prepare the SQL and execute. my $sth = $dbh->prepare( $sql ); $sth->execute( ); # Fetch output rows into array, plus prepare a # print formatter for the results. while ( my($helloWorldString) = $sth->fetchrow_array) { # Print out the result. print $helloWorldString, "\n"; } $dbh->disconnect( ); # Disconnect
Perl lib version (v5.6.1) doesn't match executable version (v5.14.0) at E:\oracle\product\10.1.0\Db_2\perl\5.6.1\lib\MSWin32-x86/Config.pm line 21. Compilation failed in require at E:\oracle\product\10.1.0\Db_2\perl\5.6.1\lib\MSWin32-x86/DynaLoader.pm line 25. BEGIN failed--compilation aborted at E:\oracle\product\10.1.0\Db_2\perl\5.6.1\lib\MSWin32-x86/DynaLoader.pm line 25. Compilation failed in require at E:\oracle\product\10.1.0\Db_2\perl\site\5.6.1\lib/DBI.pm line 152. BEGIN failed--compilation aborted at E:\oracle\product\10.1.0\Db_2\perl\site\5.6.1\lib/DBI.pm line 152. Compilation failed in require at E:\Perl\d.pl line 5. BEGIN failed--compilation aborted at E:\Perl\d.pl line 5.
In reply to Error during connecting oracle 10g by paresh2011
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |