Code: Select all
string[] s = File.ReadAllLines(@"c:\temp\test.txt");
connectionString = Helper.GetConnectionString();
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
using (OracleCommand cmd = Helper.CreateCommand("proc_clob"))
{
cmd.Connection = connection;
//note-this extension method on cmd takes the name of param, type, and value
cmd.AddInputParameter<string[]>("data", OracleDbType.Clob, s);
cmd.ExecuteNonQuery();
}
}