错误：ORA-01704：字符串文字太长 [英] Error : ORA-01704: string literal too long

问题描述

虽然我尝试在数据类型 CLOB 的字段上设置超过4000个字符的值，但它给我这个错误：

While I try to set the value of over 4000 characters on a field that has data type CLOB, it gives me this error :

ORA-01704：字符串文字太长。

ORA-01704: string literal too long.

任何建议，如果我必须设置无限个字符的值，那么哪种数据类型适用于我。要大约 15000 字符。

Any suggestion, which data type would be applicable for me if I have to set value of unlimited characters although for my case, it happens to be of about 15000 chars.

注意：我试图存储的长字符串编码在ANSI 。

Note : The long string that I am trying to store is encoded in ANSI.

推荐答案

在使用CLOB时使用什么？

What are you using when operate with CLOB?

所有事件都可以用PL / SQL来实现

In all events you can do it with PL/SQL

DECLARE
  str varchar2(32767);
BEGIN
  str := 'Very-very-...-very-very-very-very-very-very long string value';
  update t1 set col1 = str;
END;
/

SQLFiddle上的证明链接

这篇关于错误：ORA-01704：字符串文字太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！