Devart Forums

Code: Select all

using (FileStream streamToSaveLobTo = new FileStream(@"C:\temp\someFile.bmp", FileMode.OpenOrCreate, FileAccess.Write))
{
	using (OracleConnection myConn = new OracleConnection("CONNECTION STRING HERE"))
	{
		int BUFF_SIZE = 10000;
		myConn.Open();
		using (OracleCommand myCommand = new OracleCommand("Select Blob_column from TableWithBlob and rownum = 1" , myConn))
		{
			myCommand.Cached = false;
			myCommand.CommandType = System.Data.CommandType.Text;

			OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
			OracleLob oracleBlob = null;
			if (myReader.Read())
			{
				oracleBlob = myReader.GetOracleLob(0);
				oracleBlob.Cached = false;

				int bytesRead = 0;
				byte[] chunk = new byte[BUFF_SIZE];
				//each interation memory size increases by buffer size
				while ((bytesRead = oracleBlob.Read(chunk, 0, BUFF_SIZE)) > 0)
				{
					streamToSaveLobTo.Write(chunk, 0, bytesRead);
					streamToSaveLobTo.Flush();
				}
				
			}
			myConn.Close();
		}
	}
	streamToSaveLobTo.Flush();
	streamToSaveLobTo.Close();
}