加载中…OracleORA-02070:databaseXXDBLINKdoesnotsupportSUBSTRinthiscontext
(2024-12-29 17:49:38)
标签：
ora-02070hs_fds_capability |
分类： 技术类 |
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
解决方法
实例名/dbhs/admin/initmyodbc.ora
添加：
HS_FDS_CAPABILITY=SUBSTR/ON
-- 刘轶鹤
喜欢
0
赠金笔