Unix Shell Script (KSH example):
------------- Beginning of Script---------------------------------
#execScript.sh
#Execute Oracle query (SQL)/stored procedure (PL/SQL)
#Created Date: March 15, 2008
ORACLE_HOME=/oracle/theDBName/10.2.0; export ORACLE_HOME
ORACLE_SID=theDBName; export ORACLE_SID
sqlloc=$ORACLE_HOME/bin; export sqlloc

bindir=/server_folder/sales/bin; export bindir
logdir=/server_folder/sales/log; export logdir

ddate=`date +%Y%m%d`; export ddate

echo "Monthly Sales load on `date +%m/%d/%Y`:" > $logdir/$ddate_execScript.log
$sqlloc/sqlplus /nolog @$bindir/execScript >> $logdir/$ddate_execScript.log
if [ $? -ne 0 ]
  then
    echo "Error - Processing Invoice Files for $ddate" 
    echo "Error - Processing Invoice Files for $ddate" >> \
     $logdir/$ddate_execScript.log
    exit 1
fi

------------- End of Script---------------------------------------
Notes:
1. # - Signifies comment in Unix shell script (KSH) 
2. The "theDBName" has to be replaced by actual database name
3. execScript will be execScript.sql file in the bin directory