ORA-30001: trim set should have only one character
Cause: Trim set contains more or less than 1 character. This is not allowed in TRIM function.
Action: Change trim set to have only 1 character.
ORA-30001:TRIM设置只能有一个字符。
案例:
SQL> select trim( ‘abcd’ from ‘123abcd456’ ) from dual;
1. 检查传入的第二个参数是否只有一个字符,否则会报此错误。
2. 修改参数使其只有一个字符,重新执行语句。