[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指令碼了.