ITPub博客

首页 > 大数据 > 数据挖掘 > SP2-0232 Input toowwwtl503com 153316O6951ong. Must be less than 241 characters

SP2-0232 Input toowwwtl503com 153316O6951ong. Must be less than 241 characters

原创 数据挖掘 作者:wwwljxbscom 时间:2021-01-13 16:14:08 0 删除 编辑

1.环境:
SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

$ cat cc.txt
select
'&&1'
from dual;

2.测试:

SCOTT@book> @ cc.txt
Enter value for 1: aaaaaa...aaaaaaaa
--//输入足够多的字符.
SP2-0232: Input too long. Must be less than 241 characters

--//也就是输入串最长241个字符.
--//如果输入足够长.

$ cat cc.txt
select
'aaaaa...a' cx
from dual;

$ awk '{print length}' cc.txt
6
2499
10

SCOTT@book> @ cc.txt
SP2-0027: Input is too long (> 2499 characters) - line ignored
from dual
*
ERROR at line 2:
ORA-00936: missing expression

$ oerr sp2 232
00232,0, "Input too long. Must be less than %d characters\n"
// *Cause:  The input value was too long.
// *Action: Reduce the size of the value and re-enter.

$ oerr sp2 27
00027,0, "Input is too long (> %d characters) - line ignored\n"
// *Cause:  The input value specified was too long.
// *Action: Re-enter with fewer characters.

--//也就是sqlplus有这个限制,替换串最大长度小于241.而语句的最大行长度是2488.
--//只所以有这个测试,我想给ashtop增加一个查询特定表的sql语句.发现替换串太长,看来只能直接修改ashtop脚本了.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69993067/viewspace-2749745/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2021-01-12

  • 博文量
    13
  • 访问量
    5335