.net富文本编辑器中大文本写入Oracle（string转clob）

后台封装方法

	/// <summary>
        /// 用于牵涉到写入Orcale的string转clob录入数据库
        /// </summary>
        /// <param name="tempClobName">oracle临时变量名</param>
        /// <param name="strContent">需要封装到oracle临时变量里的strContent</param>
        /// <param name="sql">sql执行语句</param>
        /// <returns></returns>
        public static bool OrcaleSetClob(string tempClobName,string strContent, string sql)
        {
            bool flag = false;
            //============================================ 
            OracleConnection connt = new OracleConnection(ConfigurationSettings.AppSettings["AHPortalConnectionString"]);
            connt.Open();
            //要使用clob必须使用事务,要保证大文本完全被插入，否则失败
            OracleTransaction oxt = connt.BeginTransaction();
            OracleCommand cmd = connt.CreateCommand();
            try
            {
                //事务负载在command的执行过程中.
                cmd.Transaction = oxt;
                //Step1.创建临时的Lob 
                //Oracle server syntax to obtain a temporary LOB.
                cmd.CommandText = "DECLARE A clob; BEGIN DBMS_LOB.CREATETEMPORARY(A, FALSE); :LOC := A; END;";
                //Bind the LOB as an output parameter.
                OracleParameter p = cmd.Parameters.Add("LOC", OracleType.Clob);
                p.Direction = ParameterDirection.Output;

                //Execute (to receive the output temporary LOB).
                cmd.ExecuteNonQuery();
                //Return the temporary LOB.
                OracleLob tempLob = (OracleLob)p.Value;
                //Step 2.把文本转换为字节数组.
                System.Text.UnicodeEncoding converter = new System.Text.UnicodeEncoding();
                byte[] buffer = converter.GetBytes(strContent);
                //Step 3.把字节数组封装到OracleLob对象里面去
                tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);
                tempLob.Write(buffer, 0, buffer.Length);
                tempLob.EndBatch();
                cmd.Parameters.Clear();
                //Text方式定义
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.Add(new OracleParameter(tempClobName, OracleType.Clob)).Value = tempLob;
                cmd.CommandText = sql;
                //执行
                flag = cmd.ExecuteNonQuery() > 0 ? true : false;
                oxt.Commit();
            }
            catch (Exception)
            {
                flag = false;
                oxt.Rollback();
            }
            finally
            {
                conn.Close();
            }
            return flag;
        }

前台调用

	string tempLob = "tempLob";         //此地方为oracle临时变量名命名
        string sql = string.Format("update  T_WEB_NEWS set CATE_ID={0},"
                            + "TITLE='{1}',"
                            + "CONTENT={2},"
                            + "UPDATETIME=sysdate,"
                            + "STATUS='{3}',"
                            + "ISSLIDE='{4}',"
                            + "ISTOP='{5}' "
                            + "where ID={6}",
                            strCateID,
                            Common.FilterSQuotes(strTitle),
                            ":" + tempLob,        //注意前面要加冒号:
                            strType,
                            strIsSlide,
                            strIsTop,
                            strNewsID);
        bool res = DBUtility.OrcaleSetClob(tempLob, strContent, sql);