[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脚本了.