Oracle Clob字段过长保存出错改如何解决?


当前第2页 返回上一页

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

OracleConnection Con = new System.Data.OracleClient.OracleConnection(connectStr);

           try

           {

decimal MsgId = 20;

               string InsertSql = @"insert into MSG

                                 (ID, TITLE, CONTENT, SORT, TIME, AUTHOR, GROUP)

                               values

                                 (:ID,

                                  :TITLE,

                                  :CONTENT,

                                  :SORT,

                                  :TIME,

                                  :AUTHOR,

                                  :GROUP)";

Con.Open();

               OracleCommand cmd = new OracleCommand(InsertSql, Con);

               OracleParameter TITLE = new OracleParameter("TITLE", OracleType.NVarChar);

               OracleParameter CONTENT = new OracleParameter("CONTENT", OracleType.Clob);

               OracleParameter GID = new OracleParameter("GID", OracleType.NVarChar);

               OracleParameter SORT = new OracleParameter("SORT", OracleType.Number);

               OracleParameter TIME = new OracleParameter("TIME", OracleType.DateTime);

               OracleParameter AUTHOR = new OracleParameter("AUTHOR", OracleType.NVarChar);

               OracleParameter GROUP = new OracleParameter("GROUP", OracleType.NVarChar);

TITLE.Value = Model.MsgTitle;

CONTENT.Value = Model.MsgContent;

ID.Value = Guid.NewGuid().ToString();

SORT.Value = MsgId;

TIME.Value = DateTime.Now;

AUTHOR.Value = Model.MsgAuthor;

GROUP.Value = Model.GroupId;

               cmd.Parameters.Add(MSGTITLE);

               cmd.Parameters.Add(MSGCONTENT);

               cmd.Parameters.Add(MSGID);

               cmd.Parameters.Add(MSGSORT);

               cmd.Parameters.Add(MSGTIME);

               cmd.Parameters.Add(MSGAUTHOR);

               cmd.Parameters.Add(MGSGROUP);

               cmd.ExecuteNonQuery();

               Con.Close();

 

           }

           catch (Exception ex)

           {

 

           }

以上就是 Oracle Clob字段过长保存出错改如何解决?的详细内容!

返回前面的内容

相关阅读 >>

.net core创建一个控制台(console)程序

.net和c#有什么区别

25种.net开发不可错过的高效工具

c# 数组作为参数传递出现的问题解决

asp .net 面试题及答案分享

详细介绍.net并行与多线程学习基础

c# 中十进制与二进制、十六进制、八进制转换详解

总结.net mvc实现长轮询实例

c#中匿名对象与var以及动态类型 dynamic的详解

.net连接oracle出现ora-12514错误

更多相关阅读请进入《oracle》频道 >>




打赏

取消

感谢您的支持,我会继续努力的!

扫码支持
扫码打赏,您说多少就多少

打开支付宝扫一扫,即可进行扫码打赏哦

分享从这里开始,精彩与您同在

评论

管理员已关闭评论功能...