Shell Programming and Scripting

Hi

I have a shell script which is running fine in unix. But if i call the shell script thro informatica workflow post session command task it is not giving me the sum(amount) to a output text file

The sql_configh.sh file has uid@db/pwd

script_path="/path"
cd $script_path

connstr=`grep "uid@db" $script_path/sql_config.sh`

touch $script_path/sum_cr_amt.txt
chmod 777 $script_path/sum_cr_amt.txt


sqlplus -s > $script_path/sum_cr_amt.txt <<eof1
$connstr
select round(sum (entered_cr),2) entered_cr from table_name
where trunc(date_created)='04-jan-2008';

eof1

x=$?

if [ x -ne 0 ]
then
exit 1
fi
exit 0

I need your gr8 help

Thanks
Babu

What errors do you get? Have you checked the logs? Probably sqlplus path is not defined and also, make sure that the ORACLE_HOME path is defined.
Define this in your script.

Code:

export ORACLE_HOME=/path/to/oracle/home
$ORACLE_HOME/bin/sqlplus ..... #rest of the stuff