ITPub博客

首页 > 数据库 > Oracle > [20210113]SP2-0232 Input too long. Must be less than 241 characters.txt

[20210113]SP2-0232 Input too long. Must be less than 241 characters.txt

原创 Oracle 作者:lfree 时间:2021-01-13 11:35:11 0 删除 编辑

[20210113]SP2-0232 Input too long. Must be less than 241 characters.txt

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/267265/viewspace-2749594/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2818
  • 访问量
    6618280