C# (CSharp) Oracle.DataAccess.Types.OracleClob Examples

Example #1

File: clsOracle.cs Project: matrica15/SISPK-BACKEND-PUBLIC

 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();
         }
     }
 }

Example #2

 public Form1()
 {
     InitializeComponent();
     Oracle.DataAccess.Types.OracleClob c = null;
 }