Read Oracle BLOB data as chunks
I have the following queries on fetching a BLOB data from Oracle (
I am trying to use OracleDataReader
- .Net to read the BLOB value.):
Is it possible to read a BLOB data on Oracle database as chunks without loading the entire BLOB on to server memory? I believe OracleDataReader.GetBytes()
will loa开发者_如何学Pythond the entire blob on server memory.
Passing a null buffer on to GetBytes()
fetches the size of the BLOB but would that require the BLOB to be loaded on server's memory?
What would be the optimal way to fetch the BLOB size and BLOB data as chunks without loading the entire BLOB in memory?
Look at DBMS_LOB.READ
精彩评论