Hi list. I need to put a script in cron, but this script needs exec some Oracle variables for work fine, these variables are: export ORACLE_HOME=/oracle/app/product/9.2.0 export ORACLE_SID=galdb export LD_LIBRARY_PATH=/oracle/app/product/9.2.0/lib32 export NLS_LANG='MEXICAN SPANISH_MEXICO.WE8MSWIN1252' export NLS_NUMERIC_CHARACTERS='.,'
However when I try to exec these variables in the script (with "system" or "exec"), does not work well, this a part of my script: #!/usr/bin/perl use strict; system "export ORACLE_HOME=/oracle/app/product/9.2.0"; system "export ORACLE_SID=galdb"; system "export LD_LIBRARY_PATH=/oracle/app/product/9.2.0/lib32"; system "export NLS_LANG=\'MEXICAN SPANISH_MEXICO.WE8MSWIN1252\'"; system "export NLS_NUMERIC_CHARACTERS=\'.,\'"; use DBI; use DBD::Oracle qw(:ora_types); If I run these script manually (without cron) works fine !!!!. The error message that I see when run with cron is this: Can't load '/usr/local/lib/perl5/site_perl/5.8.2/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/bin/perl: fatal: /oracle/app/product/9.2.0/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.2/sun4-solaris/DynaLoader.pm line 229. at /home/horus/SCRIPTS/./estadisticas.pl line 11 Compilation failed in require at /home/horus/SCRIPTS/./estadisticas.pl line 11. BEGIN failed--compilation aborted at /home/horus/SCRIPTS/./estadisticas.pl line 11. Regards !!! -- _______________________________________________ Get your free email from http://mymail.bsdmail.com Powered by Outblaze -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
