Hello, When I work with java, there are no issues, I can connect to my Oracle database very easily. But when I work with perl (ActivePerl: 5.8.8), here come the troubles! I can't connect to my Oracle DB. this is what I get when I try to do a simple tOracleInput and run the job: -------------- Starting job xxx at 18:09 26/11/2007. DBI connect('host=xxx;sid= xxx;port=xxx','xxx',...) failed: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at \\xxx\xxx\xxx\xxx\xxx\logiciel\TOS-All-r7019-V2.3.0M1\workspace\.Perl\ALIMENTATION.job_xxx.pl line 393 can't connect to database at \\xxx\xxx\xxx\xxx\xxx\logiciel\TOS-All-r7019-V2.3.0M1\workspace\.Perl\ALIMENTATION.job_xxx.pl line 393. Job xxx ended at 18:09 26/11/2007. ------------- I've downloaded all the package needed, especially DBD-Oracle (1.17): In the tab "module" of TOS, everything about Oracle seems to be well installed. I've also checked my environment variable and run the script you put in the forum: Starting job xxx at 18:27 26/11/2007. ORACLE_HOME: C:\OraHome1 NLS_LANG: FR_FR === PATH C:\Program Files\Java\jre1.6.0_03\bin\client C:\Program Files\Java\jre1.6.0_03\bin C:\Perl\bin\ C:\OraHome1\bin C:\Program Files\Oracle\jre\1.1.8\bin C:\Program Files\Oracle\jre\1.3.1\bin C:\Program Files\Business Objects\common\3.5\bin\NOTES\ C:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA\ C:\WINDOWS\system32 C:\WINDOWS C:\WINDOWS\System32\Wbem === Job xxx ended at 18:27 26/11/2007. I'm on windows xp, an oracle client is installed locally (9.2) Thanks for your help! Regards
When I use the following script: #!/usr/bin/perl -w use DBI; use DBD:racle; use strict; my $dbname = 'xxx'; my $user = 'xxx'; my $passwd = 'xxx'; my $dbh = DBI->connect("dbiracle:$dbname", $user, $passwd) or die "Database connection not made: $DBI::errstr"; $dbh -> disconnect; I've got this error: L'application ou la DLL C:\Perl\bin\OraOCIEI10.dll n'est pas une image Windows valide. Verifiez à l'aide de votre disquette d'installation. and then I've got the same error with the NLS....
Hi, Have you tried to reinstall your DBD-Oracle module : from a command line ppm remove DBD-Oracle ppm install DBD-Oracle You should be prompted during the installation to download the Oracle client. Hope this helps.
Hi, Thank you for your answer. When I look in C:\Perl\bin, the size of oraociei10.dll is 0. I've removed DBD-Oracle and I'm trying to reinstall it but it doesn't work: Do you accept the terms of this license ? (y/n) : y Fetching oci.dll.gz (94 Kb) 94Kb/94Kb (100.00%) Decompressing. oci.dll checksum: OK Fetching oraociei10.dll.gz (28 Mb) 28Mb/28Mb (100.00%) DecompressingCan't call method "gzread" on an undefined value at install_script line 149. ppm install failed: Command exits with 2: C:\Perl\bin\perl.exe install_script stopped