title: External table truncates trailing whitespace while reading from file
body: <p>I'm trying to load the file contents to an external table. While doing this, trailing spaces are truncated.</p>
  <pre><code>'CREATE TABLE ' || rec.ext_table_name || ' (ROW_DATA VARCHAR2(4000)) ORGANIZATION EXTERNAL ' ||
       '(TYPE ORACLE_LOADER DEFAULT DIRECTORY ' || rec.dir_name || ' ACCESS ' || 'PARAMETERS (RECORDS ' ||
       'DELIMITED by NEWLINE NOBADFILE NODISCARDFILE ' ||
       'FIELDS REJECT ROWS WITH ALL NULL FIELDS (ROW_DATA POSITION(1:4000) char)) LOCATION (' || l_quote ||
       'temp.txt' || l_quote || ')) REJECT LIMIT UNLIMITED'
  </code></pre>
  <p>For example, with <code>B</code> representing a blank space, my file has:</p>
  <pre><code>Line1sometextBBBBBBB
  </code></pre>
  <p>My external table reads that as just:</p>
  <pre><code>Line1sometext
  </code></pre>
  <p>I want the file to be loaded with blanks too. How can I stop it removing the trailing whitespace?</p>
  <p><strong>Current Problem is :</strong></p>
  <p>if file has:</p>
  <blockquote>
  <p>&quot;this is a test value with</p>
  <p>&quot;</p>
  </blockquote>
  <pre><code> ^   this new line is also a part of the row_data.
  </code></pre>
  <p><a href="https://i.stack.imgur.com/td9Yo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/td9Yo.jpg" alt="the problem" /></a></p>