如何在asp.net下操纵oracle的blob字段呀

[knightufp]

将图片存储到oracle数据库中，用blob字段，但是不知道怎么操纵，将图片写入和读出
，各位大虾帮帮忙，小弟先谢过了

[saucer]

read the image into a byte array, for example

FileStream fs = new FileStream(@"C:\winnt\Gone Fishing.BMP", FileMode.OpenOrCreate, FileAccess.Read);

byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));

fs.Close();

then assign the byte array to a parameter, see http://groups.google.com/groups?selm=73986c9d.0112171321.214b0f7f%40posting.google.com&oe=UTF-8&output=gplain

never tried, so it might not work, :-)

[knightufp]

谢谢，我用存储过程，使用oracle的对象来操纵，不知道可以不可以

[saucer]

download .NET Managed Provider for Oracle

see
HOW TO: Pass a BLOB as a Parameter to an Oracle Package by Using the .NET Managed Provider for Oracle

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322796