在Windows Form C#中从oracle中获取BLOB文件

string connectionString = "Data Source=your_oracle_connection_string";
OracleConnection connection = new OracleConnection(connectionString);

connection.Open();

string query = "SELECT blob_column FROM your_table WHERE condition";
OracleCommand command = new OracleCommand(query, connection);

OracleDataReader reader = command.ExecuteReader();
if (reader.Read())
{
    // 读取BLOB数据
    OracleBlob blob = reader.GetOracleBlob(0);
    byte[] buffer = new byte[blob.Length];
    blob.Read(buffer, 0, (int)blob.Length);

    // 处理BLOB数据，例如保存到本地文件
    string filePath = "path_to_save_blob_file";
    File.WriteAllBytes(filePath, buffer);
}

connection.Close();