Oracle Processing CLOB Field methods

Not original, excerpted from the script house.

Inserting more than 4,000 characters into Oracle will report an exception. SQL Server has no limitations it is said to be able to insert 26W

Using Component System.Data.OracleClient

String conn = "Data source= client Specifies the connection string; User Id=user; Password=mima ";

OracleConnection Con = new System.Data.OracleClient.OracleConnection (conn);
Con.open ();
String cmdtext = "INSERT into gwexpointlist (ID, name, content) VALUES (1, ' name ',: CLOB)";
OracleCommand cmd = new OracleCommand (Cmdtext, Con);
OracleParameter op = new OracleParameter ("Clob", Oracletype.clob);
Op. Value = "an extraordinary string exceeding 4000 characters";
Cmd. Parameters.Add (OP);
Cmd. ExecuteNonQuery ();
Con.close ();

Oracle Processing CLOB Field methods