I have just arrived in Oracle recently. . Just encountering a problem, it is to store a big text, when I find a solution, I found that many people have encountered similar problems. At the beginning I also asked in the 9CBS ASP.NET version, as if it is not I want, finally found a code (VB.NET) on a site in foreign countries, I changed to C #: // Insertsql is the statement directly inserted, Content is a big text public void insertcontent (String Insertsql, String Content) ) {try {OraHelper DB = new OraHelper (); System.Data.OracleClient.OracleConnection Con = (System.Data.OracleClient.OracleConnection) DB.OpenDb (); System.Data.OracleClient.OracleCommand Cmd = new OracleCommand (InsertSql, Con); System.Data.OracleClient.OracleParameter Temp = new OracleParameter ( "TempContent", OracleType.Clob); Temp.Direction = ParameterDirection.Input; Temp.Value = Content; cmd.Parameters.Add (Temp); cmd.ExecuteNonQuery (); (Exception E) {throw new exception: " E.MESSAGE);} finally {con.
The above code test is passed, the call mode is: Content is a Clob type: InsertContent ("INSERT INTO TABLECLOB (ID, Content) VALUES (1,: TempContent", BigContent) Feedback CLOB field .. NET has a special method
I hope that people who encounter the same problem a little help.
