Shell Programming and Scripting

I am trying to run a script which makes use of these environment variables, hence i need to export them out.

i've posted a similar post in an oracle forum. I've posted the same qn here to get some advise on the scripting aspect.

i execute my program in an unix environment by typeing "export_file.sh myscript.pl" at the prompt.
it runs successfully. However when i set cronjob
0 2 * * * export_file.sh myscript.pl, i get a load of error messages.

my export file----------

Code:

export ORACLE_BASE=/directory1/oracle
export ORACLE_HOME=/directory1/oracle/product/9.0.1
export ORACLE_TERM=386
export LC_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=.:$PATH:$ORACLE_HOME/bin
export DBSTR='dbi:Oracle:'
export DBUSER='username/pass@abc'

--------below is my perl script-----

Code:

use DBI;use ENV;
my $dbh = DBI->connect($DBSTR, $DBUSER, '', { AutoCommit => 0 } ) 
my $sth = $dbh->prepare( "--some statement; END;" ) 
$sth->execute() 
$sth->finish();

----- The error message i got is ------
DBI connect('','username/pass@abc',...) failed: Error while trying to retrieve
text for error ORA-12154 (DBD ERROR: OCIServerAttach) at myscript.pl line 20
Can't call method "prepare" without a package or object reference at myscript.pl line 21.

#ERROR : Error while trying to retrieve text for error ORA-12154 (DBD ERROR:
OCIServerAttach).

Why dont you run the script as
. .export.sh
from your .profile file. Then your current shell will have this parameters set. Or if it should be visible to all users put the variable declarations in /etc/profile file.

Hi ranj@chn,

thank you for your reply. It was a silly mistake. Some of my paths were invalid. I amended the paths, and it could work.