RE: Trouble running a script with cron
From: Bob Showalter (Bob_Showalter_at_taylorwhite.com)
Date: 12/29/04
- Next message: Peter Rabbitson: "Copying a hash-of-hashes"
- Previous message: Rafael Morales: "Trouble running a script with cron"
- Maybe in reply to: Rafael Morales: "Trouble running a script with cron"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: 'Rafael Morales' <daredevil@bsdmail.com>, beginners@perl.org Date: Wed, 29 Dec 2004 15:42:57 -0500
Rafael Morales wrote:
> 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=\'.,\'";
This should be written as:
BEGIN {
$ENV{ORACLE_HOME} = '/oracle/app/product.9.2.0';
$ENV{ORACLE_SID} = 'galdb';
... and so on ...
}
The BEGIN { } block is probably needed so the vars are set before the "use
DBD::Oracle" happens.
The system() approach won't work because it only changes the environment
variables in the child process; you need to set the %ENV hash instead.
(But you may want to consider setting the variables in the crontab instead
of here)
HTH
- Next message: Peter Rabbitson: "Copying a hash-of-hashes"
- Previous message: Rafael Morales: "Trouble running a script with cron"
- Maybe in reply to: Rafael Morales: "Trouble running a script with cron"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
