DECLARE
   v_clob_data      CLOB;
   v_blob_data      BLOB;
   v_clob_len       NUMBER;
   v_position       NUMBER;
   --v_raw_chunk       RAW(10000);
   v_char           CHAR (1);
   c_chunk_len      NUMBER := 1;
   v_line           VARCHAR2 (32767) := NULL;
   v_data_array     wwv_flow_global.vc_arr2;
   v_rows           NUMBER;
   v_count          NUMBER := 0;
   v_add            NUMBER := 1;
   v_file_size      INTEGER := DBMS_LOB.lobmaxsize;
   v_dest_offset    INTEGER := 1;
   v_src_offset     INTEGER := 1;
   v_blob_csid      NUMBER := DBMS_LOB.default_csid;
   v_lang_context   NUMBER := DBMS_LOB.default_lang_ctx;
   v_warning        INTEGER;
   sep              VARCHAR2 (1) := '~';
BEGIN
   DELETE FROM BO_TEST_CSV;

   DBMS_LOB.createtemporary (v_clob_data, TRUE);

   -- Read data from wwv_flow_files
   SELECT blob_content
     INTO v_blob_data
     FROM wwv_flow_files
    WHERE last_updated = (SELECT MAX (last_updated) FROM wwv_flow_files)
          AND id = (SELECT MAX (id) FROM wwv_flow_files);

   DBMS_LOB.CONVERTTOCLOB (v_clob_data,
                           v_blob_data,
                           v_file_size,
                           v_dest_offset,
                           v_src_offset,
                           v_blob_csid,
                           v_lang_context,
                           v_warning);

   v_clob_len := DBMS_LOB.getlength (v_clob_data);
   v_position := 1;

   -- Read and convert binary to char
   WHILE (v_position <= v_clob_len)
   LOOP
      -- v_raw_chunk := dbms_lob.substr(v_clob_data,c_chunk_len,v_position);
      v_char := DBMS_LOB.SUBSTR (v_clob_data, c_chunk_len, v_position);
      -- v_char := chr(hex_to_decimal(rawtohex(v_raw_chunk)));
      v_line := v_line || v_char;
      v_position := v_position + c_chunk_len;

      IF v_char = CHR (10)
      THEN
         -- Convert comma to : to use wwv_flow_utilities
         -- v_line := REPLACE (v_line, ',', ':');
         -- Convert each column separated by : into array of data
         -- v_data_array := wwv_flow_utilities.string_to_table (v_line);
         v_line := REPLACE (v_line, ',', '~');
         v_data_array := wwv_flow_utilities.string_to_table (v_line, sep);

         IF v_count > 0
         THEN
            EXECUTE IMMEDIATE 'insert into SRS_COMC_DATA(OUTAGE,TAR_#,CUSTOMER_NAME,SEVERITY,PRIORITY,RECEIVED,RESOLUTION_TIME)
 values (:1,:2,:3,:4,:5,:6,:7)'
               USING v_data_array (1),
                     v_data_array (2),
                     v_data_array (3),
                     v_data_array (6),
                     v_data_array (7),
                     v_data_array (4),
                     v_data_array (5);
         END IF;

         -- Clear out
         v_count := v_count + v_add;
         v_line := NULL;
      END IF;
   END LOOP;
END;

OUTAGE          VARCHAR2(4000)	         
TAR_#           VARCHAR2(4000)	  
CUSTOMER_NAME   VARCHAR2(4000)	
SEVERITY,       VARCHAR2(1)
PRIORITY,       VARCHAR2(1)
RECEIVED,       VARCHAR2(4000)
RESOLUTION_TIME VARCHAR2(4000)

811953,  7634826.993,  3D SYSTEMS,    7/30/2009 0:00,   5:07:00,          1,         1
------   -----------   -------------  ---------------   ---------------   --------   --------
outage   tar_#         customer_name  received          resolution_time   severity   priority

OUTAGE          VARCHAR2(4000)
TAR_#           VARCHAR2(4000)	  
CUSTOMER_NAME   VARCHAR2(4000)	
SEVERITY,       VARCHAR2(1)      -> changed to NUMBER(1), as you wanted it to
PRIORITY,       VARCHAR2(1)      -> changed to NUMBER(1), as you wanted it to
RECEIVED,       VARCHAR2(4000)
RESOLUTION_TIME VARCHAR2(4000)

SQL> desc apex_test
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OUTAGE                                             VARCHAR2(4000)
 TAR_#                                              VARCHAR2(4000)
 CUSTOMER_NAME                                      VARCHAR2(4000)
 SEVERITY                                           NUMBER(1)
 PRIORITY                                           NUMBER(1)
 RECEIVED                                           VARCHAR2(4000)
 RESOLUTION_TIME                                    VARCHAR2(4000)

SQL>

load data
infile check.csv
replace
into table apex_test
fields terminated by ','
trailing nullcols
  (outage,
   tar_#,
   customer_name,
   received,
   resolution_time,
   severity,
   priority
)

SQL> $sqlldr scott/tiger@ora10 control=test8.ctl log=test8.log

SQL*Loader: Release 10.2.0.1.0 - Production on Sri Lip 9 11:53:29 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Commit point reached - logical record count 64
Commit point reached - logical record count 98

SQL> select count(*) from apex_test;

  COUNT(*)
----------
        98

SQL> select * from apex_test where rownum < 6;

OUTAGE     TAR_#            CUSTOMER_NAME          SEVERITY   PRIORITY RECEIVED        RESOLUTION
---------- ---------------- -------------------- ---------- ---------- --------------- ----------
811953     7634826.993      3D SYSTEMS                    1          1 7/30/2009 0:00  5:07:00
791540     7498330.993      3D SYSTEMS                    1          2 5/10/2009 0:00  1:47:00
797537     21347888.6       A3I                           1          2 6/7/2009 0:00   1:30:00
796302     21321260.6       AAFES                         1          1 5/31/2009 0:00  1:00:00
791043     21212668.6       ACHIEVO CORP                  1          1 5/8/2009 0:00   0:28:00

SQL>