Shell Programming and Scripting

br_Update_Proxy_Job_Run_Status()
{
 typeset -i myArgCount=$#[/B]
 if [ $myArgCount -lt 2 ]
 then
  br_PrintMessage W \
  "NOT Enough arguments [$myArgCount] for ** br_Update_Proxy_Job_Run_Status ** function"
  return $BR_WARNING_STATUS
 fi
 
 typeset    myJobRunStatusMsg="$1"
 typeset -i myRunStatusId="$2"
 typeset    myFeedID="$4"
 myLogFile="${10}"
 myProxyJobStatus="${11}"
 
 typeset    myClobFile=""[/B]
 if [ -z "$3" ]
 then  
  myWarningCount=null
 else
  myWarningCount="$3"
 fi
 
 if [ -z "$4" ]
 then  
  myFeedID=""
 else
  myFeedID="$4"
 fi
 
 if [ -z "$5" ]
 then  
  myRptTotalInsertedETL=null
 else
  myRptTotalInsertedETL="$5"
 fi
 
 if [ -z "$6" ]
 then  
  myRptTotalUpdatedETL=null
 else
  myRptTotalUpdatedETL="$6"
 fi
 
 if [ -z "$7" ]
 then  
  myRptTotalErrorETL=null
 else
  myRptTotalErrorETL="$7"
 fi
 
 if [ -z "$8" ]
 then  
  myRptRecordCount=null
 else
  myRptRecordCount="$8"
 fi
 
 
 if [ -z "$9" ]
 then  
  myTotalRejects=null
 else
  myTotalRejects="$9"
 fi
 
 if [ -z "$myLogFile" ]
 then
  myClobFile=""
 else
  myClobFile=`cat $myLogFile | sed "s/\'/''/g"`
 fi
 
 sqlplus -s $brDBCredentials  <<-EndOFSQL
 SET DEFINE OFF;
 SET SERVEROUT ON
 DECLARE
  i_run_status_id      NUMBER := $myRunStatusId;
  i_total_records     NUMBER := $myRptRecordCount;
  i_total_errors       NUMBER := $myRptTotalErrorETL;
  i_total_warnings     NUMBER := $myWarningCount;
  i_total_inserted     NUMBER := $myRptTotalInsertedETL;
  i_total_updated      NUMBER := $myRptTotalUpdatedETL;
  i_total_rejected     NUMBER := $myTotalRejects ;
  i_job_run_message    VARCHAR2(512) := '$myJobRunStatusMsg';
  i_feed_id            VARCHAR2(20) := '$myFeedID';
  i_status             VARCHAR2(20) := '$myProxyJobStatus';
  i_modlast_by         VARCHAR2(1000);
  o_sqlcode        NUMBER := 0 ;
  o_sqlmsg         VARCHAR2(1000);
 BEGIN
  $USP_UPD_JOB_RUN_STATUS
  (
   i_run_status_id,
   i_total_records,
   i_total_warnings,
   i_total_inserted,
   i_total_updated,
   i_total_errors,
   i_total_rejected,
   '$myClobFile',
   i_job_run_message,
   i_feed_id,
   i_status,
   i_modlast_by,
   o_sqlcode,
   o_sqlmsg
  );
 END; 
 /
 EndOFSQL
}