Shell Programming and Scripting

Thank you very much, it worked but there are empty lines in the log as shown below

2010-11-23 21:27 CST DEBUG: Start executing test1.sql
2010-11-23 21:27 CST
2010-11-23 21:27 CST PL/SQL procedure successfully completed.
2010-11-23 21:27 CST
2010-11-23 21:27 CST DEBUG: Completed executing test1.sql
2010-11-23 21:27 CST DEBUG: Start executing SQL loader

Those empty lines were in the output for sqlplus too. But pretty easy to remove:

Code:

logoutput()
{
   while read line
   do
       [ -n "$line" ] && echo $(date) "$line" >> logfile
   done
}
 
#Example usage:
sqlplus -s user/pass@Db <<EOF | logoutput
select * from asd;
select * from werw;
EOF