title: Loading a CLOB over 32mb using an external table
body: <p>I have an external table whose definition looks like this:</p>
  <pre><code>-- Create table
  create table EXT_EXTRACT_XMLS
  (
    extract_type  VARCHAR2(100),
    clob_filename VARCHAR2(100),
    xml_clob      CLOB
  )
  organization external
  (
    type ORACLE_LOADER
    default directory MY_DIRECTORY
    access parameters 
    (
      RECORDS DELIMITED BY NEWLINE
      BADFILE MY_DIRECTORY:'Xml_Extract.bad'
      LOGFILE MY_DIRECTORY:'Xml_Extract.log'
      FIELDS TERMINATED BY ','
      MISSING FIELD VALUES ARE NULL
      (
        extract_type  char(100),
        clob_filename char(100)
      )
      COLUMN TRANSFORMS (xml_clob FROM LOBFILE (clob_filename))
    )
    location (MY_DIRECTORY:'xml_extract_list.txt')
  )
  reject limit UNLIMITED;
  </code></pre>
  <p>Within the directory MY_DIRECTORY, I have a file named xml_extract_list.txt that looks like this:</p>
  <pre><code>A,extractA.xml
  </code></pre>
  <p>Within the same directory, I have a file extractA.xml which I am trying to load into the table, as a single row with the CLOB column in that row containing the XML.</p>
  <p>This is mostly working fine as long as the XML file is under 32mb. Once the file is over 32mb, this starts erroring and I can no longer read the CLOBs.</p>
  <p>Is this a limitation of external tables, or is there an option or parameter that I can change to load a file over 32mb as a CLOB?</p>
  <p><strong>More Information</strong></p>
  <p>The error message that I select from the table is:</p>
  <p><a href="https://i.stack.imgur.com/oNuh4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oNuh4.png" alt="selecting from table" /></a></p>
  <p>Since the column is a CLOB, I cannot use the DUMP function to investigate what is happening behind the scenes.</p>
  <p>The logfile generated by the external table is not giving any error message.</p>
  <p>The badfile generated by the external table is empty.</p>
  <p>When attempting to query it using sqlplus, it looks a bit malformed:
  <a href="https://i.stack.imgur.com/qZWwp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qZWwp.png" alt="enter image description here" /></a></p>