EXECUTE IMMEDIATE
        'create table EXT_TABLE_NAME '  ||
        ' (college_student_id   VARCHAR2(20),            '       ||
        '  term_code      VARCHAR2(6),          '       ||
        '  board_code      VARCHAR2(3),          '       ||
        '  board_date      DATE,          '       ||
        '  academic_status      VARCHAR2(2),          '       ||
        '  progress      VARCHAR2(2),          '       ||
        '  degree_status      VARCHAR2(6),          '       ||
        '  classification      VARCHAR2(6),          '       ||
        '  decision      VARCHAR2(10))          '       ||
        '  organization external '                      ||
        ' (type oracle_loader '                         ||
        '  default directory UPLOADS_DIR '             ||
        '  access parameters ( '                        ||
        '    records delimited by newline '             ||
        '    nobadfile '                                ||
        '    nologfile '                                ||
        '    nodiscardfile '                            ||
        '    fields terminated by '','''                ||
        '    missing field values are null '            ||
        '    (college_student_id, '                     ||
        '     term_code, '                                  ||
        '     board_code, '                             ||
        '     board_date DATE "dd/mm/yyyy", '        ||
        '     academic_status, '                              ||
        '     progress, '                                 ||
        '     degree_status, '                                 ||
        '     classification, '                                 ||
        '     decision) '                                 ||
        '      )'                                       ||
        '  location (''' || p_file_name || ''') )'      ||
        '  reject limit unlimited ';