Shell Programming and Scripting

TEST_VAR='HELLO WORLD'
PROC='testproc'
sqlplus apps/sup3rm5n@fmsdev3 << EOF > test1.log
set serveroutput on size 200000
whenever sqlerror continue
set echo on
exec dbms_output.put_line('$TEST_VAR');
exit;
EOF

sqlplus . . .  <<EOF | tr -d '\15' > test1.log

echo ' '^M$
echo 'ODS to Stage Synch job started ' ^M$
date^M$
echo ' '^M$
#|---------------------------------------------------------------------^M$
#| Step 1: Execute the procedure.^M$
#|---------------------------------------------------------------------^M$
PROC='OS2STG_JOB'^M$
PKG='SYNCH_JOBS'^M$
TEST_VAR='HELLO WORLD'^M$
sqlplus username/password2dbid << EOF > $LOG_DIR/$PROC.sql.log^M$
set serveroutput on size 200000^M$
whenever sqlerror continue^M$
set echo on^M$
exec dbms_output.put_line('$TEST_VAR');^M$
exit;^M$
EOF^M$