Shell Programming and Scripting

SQL1="SELECT SYSDATE FROM DUAL" 
 
sqlplus -s << EOF > ${RESULT_1}
${CONNECT}
set verify off
set feedback off
set echo off
set pagesize 0
set linesize 250
${SQL1};
${SQL2};
exit;
EOF

TODAY_DATE=`cat RESULT_1 | head -1` (RESULT_1 has other sql command's executed results too)

SQL3="INSERT INTO dips_tbl(COL1,COL2,COL3,CREATE_DATE,COL4,COL5) VALUES(${COL1},${COL2},${COL3},${TODAY_DATE},${COL4},${COL5})"

INSERT INTO dips_tbl(COL1,COL2,COL3,CREATE_DATE,COL4,COL5) VALUES(<"some value1">,<some value2>,       <some value3>,"15-MAR-10",<some value4>,<some value5>)
                                                                                                                                      *
ERROR at line 1:
ORA-00984: column not allowed here

'$col1','$col2'