title: Read Oracle BLOB data as chunks
body: <p>I have the following queries on fetching a BLOB data from Oracle (
  I am trying to use <code>OracleDataReader</code> - .Net to read the BLOB value.):</p>
  
  <p>Is it possible to read a BLOB data on Oracle database as chunks without loading the entire BLOB on to server memory? I believe <code>OracleDataReader.GetBytes()</code> will load the entire blob on server memory. </p>
  
  <p>Passing a null buffer on to <code>GetBytes()</code> fetches the size of the BLOB but would that require the BLOB to be loaded on server's memory?</p>
  
  <p><strong>What would be the optimal way to fetch the BLOB size and BLOB data as chunks without loading the entire BLOB in memory?</strong></p>