ORA-31053: The value of the depth argument in the operator cannot be negative ORACLE 报错 故障修复 远程处理
文档解释
ORA-31053: The value of the depth argument in the operator cannot be negative
Cause: The value of the depth argument passed to the primary operator is not a positive integer
Action: Pass a positive value of the depth argument
ORA-31053的错误信息是指,在运算符中深度参数的值不能是负值。
官方解释
常见案例
Column Name Data Type
————————
id VARCHAR2(250)
text VARCHAR2(4000)
当运行以下查询时,将触发此错误:
SELECT * FROM TABLE_B WHERE tokenize(text, ‘ ‘, -1)
一般处理方法及步骤
SELECT * FROM TABLE_B WHERE tokenize(text, ‘ ‘, 1)