Shell Programming and Scripting

sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << END1 >> $LOGFILE
whenever sqlerror exit
set serveroutput on size 1000000

declare
  l_rc          varchar2(1)   := null;
  l_msg         varchar2(50)  := null;
  l_note        varchar2(254) := null;
  l_tvx_recs    integer       := 0;
  cursor c1 is
    select first_name as acct_id,
           call_stus_desc as call_status_description,
           cntctd_date as contacted_date,
           cntctd_time as contacted_time,
           appt_notes as delinquency_amount
      from sr11007_call_results_table;
begin
  dbms_output.enable(1000000);
  for i in c1 loop
      l_tvx_recs := l_tvx_recs + 1;   
      l_note := 
         trim(i.contacted_date) || ' ' ||
         trim(i.contacted_time) || ' regarding ' ||
         trim(i.delinquency_amount,'$9,999,999,990.00')  || ' ' ||
         trim(i.call_status_description);