Apr 16, 2008 01:51 PM|dungbomb|LINK
Not sure if this will help you or not, but I needed to pull a BLOB back into a byte array to write it to a file. What I did was to pull the BLOB back from the database in a DataReader and use GetBytes. The code below works for me, though it is not using
a stored proc.
OracleDatabase db = new OracleDatabase(connectionString);
IDataReader dataReader = db.ExecuteReader(CommandType.Text, sqlString);
long blobLength = dataReader.GetBytes(0, 0, null, 0, 0);
byte writeBuffer = new byte[blobLength];
dataReader.GetBytes(0, 0, writeBuffer, 0, (int)blobLength);