public void InsertCLOB(string SQLStatement, string str) { if (SQLStatement.Length > 0) { if (connOracle.State.ToString().Equals("Open")) { byte[] newvalue = System.Text.Encoding.Unicode.GetBytes(str); sqlCommandOracle = new Oracle.DataAccess.Client.OracleCommand(SQLStatement, connOracle); rstOracle = sqlCommandOracle.ExecuteReader(); rstOracle.Read(); txn = connOracle.BeginTransaction(); clob = rstOracle.GetOracleClob(0); clob.Write(newvalue, 0, newvalue.Length); txn.Commit(); } } }
public Form1() { InitializeComponent(); Oracle.DataAccess.Types.OracleClob c = null; }