Script de otra persona. Pero como aprender de otro es muy buena idea lo pego aqui para poder aprender de ello.
#!/bin/bash mois=$1 annee=$2 continue=0 return_file=$DATA_TMP/return_value.tmp log=$DATA_LOG/ins.`date '+%y%m%d%H%M%S'`.log sqlplus -s $CONNECT << EOF execute stkmes( processus => 'PINS', mestxt => 'Insertion des donnees' , flag => 'CALCULDEBUT'); set feedback off; set serverout on spool $return_file execute authorize_step($1,$2,'4'); set feedback on spool off EOF line=`cat $return_file` order_process_ok=`egrep -c -e "Impossible|ORA-" $return_file` if [ $order_process_ok -eq 0 ] then addlog_notecho $log 1 $line init_plan_error $mois $annee PINS sqlplus -s $CONNECT << EOF set feedback off set serverout on set termout on spool $return_file @$HOME/sql/dispatch_all.sql spool off EOF line=`cat $return_file` exec_ok=`egrep -c -e "Erreur|ORA-" $return_file` if [ $exec_ok -eq 0 ] then continue=0 sqlplus -s $CONNECT << EOF update int_plan_processus set flagok='1', accordpar='SYSTEM' where ordre='4' and annee = '$annee' and mois = '$mois' ; execute stkmes( processus => 'PINS', mestxt => 'Insertion des donnees' , flag => 'CALCULFIN'); EOF else addlog_notecho $log 3 $line continue=1 sqlplus -s $CONNECT << EOF execute stkmes( processus => 'PINS', mestxt => 'Insertion des donnees' , flag => 'CALCULERROR'); EOF fi else addlog_notecho $log 3 $line continue=1 sqlplus -s $CONNECT << EOF execute stkmes( processus => 'PINS', mestxt => 'Insertion des donnees' , flag => 'CALCULERROR'); EOF fi if [ $continue -eq 0 ] then post_task_sas.sh $mois $annee PINS continue=$? fi exit $continue