Shell Programming and Scripting

GRAKD00CGSB002:kd20sic1:/tmp>cat x.ksh
#! /usr/bin/ksh
    
        X=`sqlplus -s apps/apps <<-eof
                select sysdate from dual;
                eof`
        echo "$X"
GRAKD00CGSB002:kd20sic1:/tmp>x.ksh

SYSDATE
---------
05-AOU-09
GRAKD00CGSB002:kd20sic1:/tmp>

insert into STN.STN_ERROR_TABLE 
       (STN,STN_SAP_MATERIAL_ATTR, SMA_FEED_RECEIVED_ID)
values ("MASTER_MATERIAL_ATTR_090709",ORA-12811,ff,gg, gopal);

#! /usr/bin/sh
 while read record
   do
        echo $record
    
       sqlplus STN/errrmddb20@MAHFDR <<EOF
insert into STN.STN_ERROR_TABLE values($record);
EOF
     X=$?
 
        echo $X
   done < ora.txt

$
$ cat testscr.sh
#! /usr/bin/sh
while read record
   do
#        echo $record
#          X=`sqlplus -s STN/errrmddb20@MAHFDR <<eof
#          insert into STN.STN_ERROR_TABLE values($record);
#          eof`
         X="sqlplus -s STN/errrmddb20@MAHFDR <<eof
         insert into STN.STN_ERROR_TABLE values($record);
         eof"
        echo $X
   done < ora.txt
$
$ . testscr.sh
sqlplus -s STN/errrmddb20@MAHFDR <<eof insert into STN.STN_ERROR_TABLE values(STN,STN_SAP_MATERIAL_ATTR, SMA_FEED_RECEIVED_ID = "MASTER_MATERIAL_ATTR_090709",ORA-12811,ff,gg, gopal); eof
sqlplus -s STN/errrmddb20@MAHFDR <<eof insert into STN.STN_ERROR_TABLE values(STN,STN_SAP_MATERIAL_ATTR, SMA_FEED_RECEIVED_ID = "MASTER_MATERIAL_ATTR_090709",ORA-12811,ff,gg, gopal); eof
sqlplus -s STN/errrmddb20@MAHFDR <<eof insert into STN.STN_ERROR_TABLE values(STN,STN_SAP_MATERIAL_ATTR, SMA_FEED_RECEIVED_ID = "MASTER_MATERIAL_ATTR_090709",ORA-12811,ff,gg, gopal); eof
$
$

'STN','STN_SAP_MATERIAL_ATTR', 'SMA_FEED_RECEIVED_ID'..
'STN','STN_SAP_MATERIAL_ATTR', 'SMA_FEED_RECEIVED_ID'..
.
.

awk -v Q="'" ' 
{ 
   Values_detail = Q Value_1 Q OFS Q Value_2 Q OFS Q Value_3 Q;
   print Q Target_schema Q, Q Target_table Q, Values_detail >ora.txt
}
' inputfile