ORA-30001: trim set should have only one character ORACLE 报错 故障修复 远程处理

文档解释

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. 修改参数使其只有一个字符，重新执行语句。