declare
     cursor customerCursor
     is select c_first||' '||c_last, c_address, c_city,c_state,c_zip ,c_dphone 
     from customer c;

      c_first    varchar2(30);
      c_last     varchar2(30);
      c_address  varchar2(30);
      c_city     varchar2(30);
      c_state    char2(2);
      c_zip      varchar2(10);
      c_dphone   varchar2(10);
     
    begin
       for c1 in (select count(c.c_id) count_c_id 
       from customer c  ) loop
        dbms_output.put_line('There are:'||c1.count_c_id);
      end loop;

      open customerCursor;
      fetch customerCursor into c_first, c_last,c_address, c_city,c_state,c_zip ,c_dphone ;
 
       dbms_output.put_line(chr(13) || chr(13));
       dbms_output.put_line('Clearwater Traders mailing List.');
       dbms_output.put_line('------------------------');

        while customerCursor%FOUND loop
        dbms_output.put_line(c_first||c_last||c_address||c_city ||c_state||c_zip ||c_dphone );
        fetch customerCursor into c_fist,c_last,c_address, c_city,c_state , c_zip,c_dphone );
      end loop;
      close customerCursor;
     end;
     /
    
ERROR