Devart Forums

Code: Select all

  string connStrDirect = "server=xxx;SID=xxx;uid=xxx;pwd=xxx;port=xxx;Direct=true;Unicode=true;";
  using (OracleConnection conn = new OracleConnection(connStrDirect)) {
    conn.Open();
    OracleCommand command = conn.CreateCommand();
    command.CommandText = "insert into CLOB_TEST(id,clob) values(1,:p1)";
    
    OracleParameter param1 = new OracleParameter();
    param1.ParameterName = "p1";
    param1.OracleDbType = OracleDbType.Clob;
    //textBefore.txt contains 28800 characters
    StreamReader re = File.OpenText(@"D:\tempClob\textBefore.txt");
    param1.Value = re.ReadToEnd();
    re.Close();

    command.Parameters.Add(param1);
    command.ExecuteNonQuery();

    command.CommandText = "select * from CLOB_TEST where CLOB_TEST.ID=1";
    command.ParameterCheck = true;
    OracleDataReader reader = command.ExecuteReader();
    reader.Read();
    int i = reader.GetOrdinal("clob");
    FileInfo t = new FileInfo(@"D:\tempClob\textAfter.txt");
    StreamWriter Tex = t.CreateText();
    Tex.Write(reader.GetString(i));
    Tex.Close(); //textAfter.txt contains 28800 characters as well
    reader.Close();
  }