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页面局部更新引发的思考

.net下关于log4net的使用方法的图文代码分享

c#中强制转换与尝试转换的实现方法

c#中关于扩展方法的实例分析

.net和c#有什么区别

c#中sql参数传入空值出错误和如何解决办法

c#中关于automapper应用的实例

pdb是什么文件?

c#关于验证身份证号码的实例分析(正确性)

.net程序如何以管理员身份自动运行的分析

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




打赏

取消

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

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

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

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

评论

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

    暂无评论...