<snipped>
#Oracle variables
oracleUID='DW'
oraclePass='password'

                #Call SqlPlus to get vaulues from Oracle using a here file then populate the variables 
                #(finaldestinationfolder reportperfdest passphrase, ...)
                sqlplus -s oracleUID/oraclePass@noah << !EOSQL | \
                  awk -F: '{printf("%s ", $1); printf("%s ", $2 ); printf("%s ", $3 )}' | \
                  read finaldestinationfolder reportperfdest passphrase
              
                WHENEVER SQLERROR  exit 5
                set define on
                set heading off
                set pagesize 0
                set feedback off
                set echo off
                column passphrase format a90
                set linesize 100
                SELECT CASE RDP.REPORT_DESTINATION 
                       WHEN 'MC' THEN RDP.MEMBERCONNECT_FOLDER 
                       WHEN 'SF' THEN RDP.SAFELINK_FOLDER 
                       ELSE 'UNKNOWN' END ||
                       ':'||RDP.REPORT_DESTINATION||':'||CP.PASSPHRASE 
                FROM SACORP.MCI, DW.CLIENT_PASSPHRASE CP, DW_REF.EI_REPORT_DEST_PREF RDP 
                WHERE MCI.PSC_ID = RDP.PSC_ID
                  AND RDP.PSC_ID(+) = CP.PSC_ID
                  AND CP.EFFECTIVE_DATE = TRUNC(SYSDATE, 'MM')
                 AND MCI.CLIENT_ID = $clientid;
              
                exit 0
              
                !EOSQL
                #End of here file and call into Oracle
<snipped>

$ ./script2.sh
destfilespath /export/home/boeprod/processfiles/destfiles/TestFiles
memberconnectpath /export/home/boeprod/processfiles/destfiles/TestFiles/MemberConnect
safelinkpath /export/home/boeprod/processfiles/destfiles/TestFiles/SafeLink
./script2.sh[61]: syntax error at line 121 : `<<' unmatched

   sqlplus << EOF
   / as sysdba
   set term on echo on
   select 'This works' from dual;
   exit
EOF

+ sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 3 19:56:54 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Enter user-name: 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> 
'THISWORKS
----------
This works

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

invalid username/password; logon denied        
ERROR   ORA-12162  TNS net service name is incorrectly specified       
SP2-0306  Invalid option.  
Usage  CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]  
where <logon> = <username>[/<password>][@<connect_identifier>] | / 
SP2-0157  unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

res=`sqlplus -s / <<EOF
set pagesize 0
set feedback off
select 1 from dual
union all
select 2 from dual
union all
select 3 from dual
/
EOF`
echo "res=$res"
echo $res | read v1 V2 v3
echo "v1=$v1 v2=$v2 v3=$v3 "

$ res=`sqlplus -s / <<EOF
set pagesize 0
set feedback off
select 1 from dual
union all
select 2 from dual
union all
select 3 from dual
/
EOF`
> set pagesize 0
> set feedback off
> select 1 from dual
> union all
> select 2 from dual
> union all
> select 3 from dual
> /
> EOF`
$ echo "res=$res"
res=         1
         2
         3
$ echo $res | read v1 V2 v3
$ echo "v1=$v1 v2=$v2 v3=$v3 "
v1=1 v2= v3=3