UNIX for Beginners Questions & Answers

#!/bin/ksh
## Batch Obj Id
MP_BCH_OBJ_ID=$1
PASS=$2
partition=$3

## script dir
RUN_DIR=$(dirname $0)

## Set/Source Environment #
cd ${RUN_DIR}


${ORACLE_HOME}/bin/sqlplus -s /nolog <<-EOF > /dev/null
conn el1acpt2/$PASS@AOWH01
spool ${SRC_DIR}/SRVC_CONV/RDW_SRVC_CONV_${MP_BCH_OBJ_ID}_$partition.dat;
set pagesize 0
set trimspool on
set heading off
set feedback off
select ACTVY_RPTNG_PER_DT||'|'||LN_ID||'|'||ARM_IDX_CD||'|'||RCRS_TYP_CD||'|'||LNDR_LN_ID from LN_ACTVY partition($3);
spool off;
EXIT;
EOF

${ORACLE_HOME}/bin/sqlplus -s  el1acpt2/$PASS@AOWH01 <<-EOF > /dev/null

#${ORACLE_HOME}/bin/sqlplus -s /nolog <<-EOF > ${LOG_DIR}/edw_extract_RDW_Partition.sh.${MP_BCH_OBJ_ID}_${partition}.sql.log
${ORACLE_HOME}/bin/sqlplus -s /nolog <<-EOF > /dev/null
conn ${APPLICATION_ID}/${DB_PASS}@${RDW_DB}
spool ${SRC_DIR}/RDW_SRVC_CONV_${MP_BCH_OBJ_ID}_${partition}.dat;
set pagesize 0
set trimspool on
set heading off
set feedback off
set linesize 500
select to_char(ACTVY_RPTNG_PER_DT,'mm/dd/yyyy hh24:mi:ss')||'|'||LN_ID||'|'||'|'||'|'||'|'||'|'||ARM_IDX_CD||'|'||'|'||'|'||'|'||'|'||'|'||'|'||RCRS_TYP_CD||'|'||'|'||'|'||LNDR_LN_ID||'|'||'|'||'|'||'|'||'${MP_BCH_OBJ_ID}'||'|'||'|'||'${MP_EDW_USR_ID}'||'|'||'${MP_BCH_STRT_DTTM}'||'|'||'|' from $RDW_Schema.LL_LN_ACTVY_3 partition(${partition});
spool off;
EXIT;
EOF

SELECT timestamp, 
       username, 
       script, 
       statement, 
       message 
FROM   sperrorlog;