title: UTL_FILE.get_line returns extra byte ORACLE
body: <p>I need check the header of a .csv file using UTL_FILE</p>
  
  <p>I need to compare the header line with a value from the database.</p>
  
  <pre><code>UTL_FILE.get_line(file_handle, buffer);
  </code></pre>
  
  <p>eg.</p>
  
  <pre><code> dbms_output.put_line( length(buffer_db)); 20
   dbms_output.put_line( length(buffer)); 21
  </code></pre>
  
  <p>the length of the varchar from the csv is one byte longer than the value from the db.  I've tried trimming it, does nothing, there are no white spaces on the ends.</p>
  
  <p>If I force the max line size it works.</p>
  
  <p>eg.</p>
  
  <pre><code>UTL_FILE.get_line(file_handle, buffer, 20);
  </code></pre>
  
  <p>Since I have to check for multiple different headers, i cant exactly do that.</p>
  
  <p>I just cant seem to figure out where this extra byte is coming from on the retrieved line.</p>