#Set the scripts Path
SCRIPTS_PATH="/usr/local/ccms/gpa/svr/scripts"
echo $SCRIPTS_PATH

#Executes SVR parameter scripts Sets all the application specific properties
 . $SCRIPTS_PATH/svrparam.sh


 $ORACLE_HOME/bin/sqlplus -s /nolog >/dev/null  <<EOF
        set feedback off
        set echo off
        set pagesize 0
        set linesize 4000
        set space 0
        set serveroutput on
        spool ${SVR_LOG_PATH}/solv_outbound_files.txt
        connect $SOLV_DB_USER/$SOLV_DB_PASS@$SOLV_DB_SERVER
        SELECT view_name||'|'||file_name||'|'||type_of_file
        FROM   client_outbound_files
        WHERE  active_ind = 'Y';
"svr_outbound_files.sh" 118 lines, 2529 characters
   else
   column_name="hol_footer"
   fi

   echo "$file_type"
   echo "column name $column_name"
   echo $now
   echo $now_mi


  $ORACLE_HOME/bin/sqlplus -s /nolog >/dev/null  <<EOF
        set feedback off
        set echo off
        set pagesize 0
        set linesize 32767
        set long 50000
        set longchunksize 50000
        set space 0
        set serveroutput on
        spool ${OUTBOUND_FILE_PATH}/${file_name}_${now}_${now_mi}.csv
        connect $SOLV_DB_USER/$SOLV_DB_PASS@$SOLV_DB_SERVER
        SELECT outbound_column
        FROM $view_name;
        spool off
EOF



done < ${SVR_LOG_PATH}/solv_outbound_files.txt