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