oracle 插入大于4000字符的 clob代码
时间:2017-03-02 10:50:30
收藏:0
阅读:369
OracleConnection connection = new OracleConnection(conn); OracleCommand command = new OracleCommand(); int result = 0; try { PrepareCommand(command, connection, CommandType.Text, cmdText); OracleParameter stopUpdateAutoCodes = new OracleParameter("StopUpdateAutoCodes", OracleDbType.Clob); stopUpdateAutoCodes.Value = mr.StopUpdateAutoCodes; command.Parameters.Add(stopUpdateAutoCodes); OracleParameter syncCodes = new OracleParameter("SyncCodes", OracleDbType.Clob); syncCodes.Value = mr.SyncCodes; command.Parameters.Add(syncCodes); OracleParameter unSyncCodes = new OracleParameter("UnSyncCodes", OracleDbType.Clob); unSyncCodes.Value = mr.UnSyncCodes; command.Parameters.Add(unSyncCodes); result = command.ExecuteNonQuery(); command.Parameters.Clear(); } catch { } finally { command.Dispose(); connection.Close(); connection.Dispose(); }
原文:http://www.cnblogs.com/valor-xh/p/6489286.html
评论(0)