开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜