OracleBFile.Read(Byte[], Int32, Int32) Method


Reads a sequence of bytes from the current OracleBFile stream and advances the position within the stream by the number of bytes read.

 override int Read(cli::array <System::Byte> ^ buffer, int offset, int count);
public override int Read (byte[] buffer, int offset, int count);
override this.Read : byte[] * int * int -> int
Public Overrides Function Read (buffer As Byte(), offset As Integer, count As Integer) As Integer



An array of bytes. When this method returns, the buffer contains the specified byte array with the values between offset and (offset + count) replaced by the bytes read from the current source.


The zero-based byte offset in buffer at which to begin storing the data read from the current stream.


The maximum number of bytes to be read from the current stream.


The total number of bytes read into the buffer. This may be less than the number of bytes requested if that many bytes are not currently available, or zero if the end of the file has been reached.


The sum of offset and count is larger than the buffer length.

buffer is a null reference (Nothing in Visual Basic).

offset or count is negative.

The connection with which a BFILE is associated is closed.

An I/O error occurred.

Methods were called after the stream was closed or disposed.


The Read method read a maximum of count bytes from the current stream and store them in buffer beginning at offset. The current position within the stream is advanced by the number of bytes read; however, if an exception occurs, the current position within the stream remains unchanged. Read returns the number of bytes read. The return value is zero only if the position is currently at the end of the stream. Read will block until at least one byte of data can be read, in the event that no data is available. Read returns 0 only when the end of the file has been reached. Read is free to return fewer bytes than requested even if the end of the stream has not been reached.

Any attempt to access a closed OracleBFile using the Read or Seek methods reopens an OracleBFile stream automatically.

The following C# example assumes this schema in an Oracle table:

(col1 number, col2 BFILE)  

The example demonstrates using the Read and Seek methods to access an OracleBFile object.

byte[] buffer = new byte[100];  
OracleDataReader dataReader = command.ExecuteReader();  
using (dataReader) {  
    if (dataReader.Read()) {  
            OracleBFile BFile = dataReader.GetOracleBFile(1);  
        using (BFile) {  
            BFile.Seek(0, SeekOrigin.Begin);  
            BFile.Read(buffer, 0, 100);  

Applies to