Oracle ORA-02070: database XXDBLINK does not support SUBSTR in this context

Oracle ORA-02070: database XXDBLINK does not support SUBSTR in this context

Cause:The remote database does not support the named capability in the context in which it was used.

Action:Simplify the SQL statement.

SQL Functions That Can Be Enabled
ABS

ACOS

ASCII

ASIN

ATAN

ATAN2

BITAND

CAST

CEIL

CHR

CONVERT

COS

COSH

COUNTCOL

DECODE

DUMP

EXP

FLOOR

GREATEST

HEXOTRAW

INITCAP

INSTR

INSTRB

LEAST

LENGTH

LENGTHB

LN

LOG

LOWER

LPAD

LTRIM

MOD

NLS_INITCAP

NLS_UPPER

NLS_LOWER

NLSSORT

NVL2

POWER

RAWTOHEX

REPLACE

REVERSE

ROUND

RPAD

RTRIM

SIGN

SIN

SINH

SQRT

STDDEV

SUBSTR

SUBSTRB

TAN

TANH

TO_NUMBER

TRANSLATE

TRIM

TRUNC

UPPER

VARIANCE

VSIZE

解决方法

/*****/实例名/db/***/hs/admin/initmyodbc.ora 
添加：
HS_FDS_CAPABILITY=SUBSTR/ON

-- 刘轶鹤