Using ORGANIZATION EXTERNAL to load a dataset from csv on sql developer (oracle)

Question

I am following a course and I got this script below that I should execute:

ORGANIZATION EXTERNAL (
      TYPE ORACLE_LOADER
      DEFAULT DIRECTORY extdir
      ACCESS PARAMETERS (
      RECORDS DELIMITED BY NEWLINE
      SKIP 1
      BADFILE extdir:'LOAD_CANDYBAR_HISTORICAL_DATA.bad'
      LOGFILE extdir:'LOAD_CANDYBAR_HISTORICAL_DATA.log'
      FIELDS TERMINATED BY ','
      OPTIONALLY ENCLOSED BY '"'
      MISSING FIELD VALUES ARE NULL
      (
                RESPONDENT_ID,
                RESPONDENT_NAME,
                RESPONDENT_ADDR,
                RESPONDENT_CITY,
                RESPONDENT_STATE,
                RESPONDENT_ZIPCODE,
                RESPONDENT_PHONE_NUM,
                RESPONDENT_GENDER,
                RESPONDENT_DOB DATE(10) "YYYY-MM-DD",
                CANDYBAR_ID,
                CANDYBAR_NAME,
                CANDYBAR_MFR_ID,
                CANDYBAR_MFR_NAME,
                CANDYBAR_WEIGHT_OZ,
                SURVEY_DATE DATE(10) "YYYY-MM-DD",
                SURVEY_YEAR,
                TASTE_RATING,
                APPEARANCE_RATING,
                TEXTURE_RATING,
                OVERALL_RATING,
                LIKELIHOOD_PURCHASE,
                NBR_BARS_CONSUMED
      )
     )
     LOCATION ('CANDYBAR_HISTORICAL_DATA_2004.csv',
            'CANDYBAR_HISTORICAL_DATA_2005.csv',
            'CANDYBAR_HISTORICAL_DATA_2006.csv',
               'CANDYBAR_HISTORICAL_DATA_2007.csv',
               'CANDYBAR_HISTORICAL_DATA_2008.csv',
               'CANDYBAR_HISTORICAL_DATA_2009.csv',
               'CANDYBAR_HISTORICAL_DATA_2010.csv',
               'CANDYBAR_HISTORICAL_DATA_2011.csv',
               'CANDYBAR_HISTORICAL_DATA_2012.csv',
               'CANDYBAR_HISTORICAL_DATA_2013.csv')
    );

In addition, I've added:

CREATE OR REPLACE DIRECTORY extdir AS '/Users/path_to/CANDYBAR_HISTORICAL_DATA/';

and inside of my CANDYBAR_HISTORICAL_DATA are all the csv.

Moreover I am having the following error:

ORA-00928: missing SELECT keyword
00928. 00000 -  "missing SELECT keyword"
*Cause:    
*Action:
Error at Line: 15 Column: 4

and I don't really understand why :(