ORA-28534: Heterogeneous Services preprocessing error

ORA-28534: Heterogeneous Services preprocessing error
Cause: One of the things that the Heterogeneous Services can do is to preprocess parts of SQL statements that contain implicit coercions or calls to explicit coercion functions like TO_CHAR TO_NUMBER or TO_DATE. For example, it could convert a call to TO_DATE to a bind variable, pre-evaluate the TO_DATE function call and pass the resulting value to the non-Oracle system as the bind value. This behavior is controlled by some coercion related capabilities. If the capabilities are set incorrectly, the HS could encounter errors when it attempts to do the preprocessing. If it does then this error will be signaled.
Action: The capability table settings are controlled by the agent vendor and can be modified by the DBA. Contact your DBA and agent vendor and get the correct set of capabilities installed.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28534：异构服务预处理错误,
.原因：异构服务可以做的事情之一是预处理包含隐式强制或调用显式强制函数（如TO_CHAR TO_NUMBER或TO_DATE）的SQL语句的部分。例如，它可以将对TO_DATE的调用转换为绑定变量，预先评估TO_DATE函数调用，并将结果值作为绑定值传递到非Oracle系统。此行为由一些强制相关功能控制。如果能力设置不正确，HS可能在尝试进行预处理时遇到错误。如果是，则会发出此错误信号。,
.操作：能力表设置由代理供应商控制，可由DBA修改。请联系您的DBA和代理供应商，并获得安装的正确功能集。,
.

aiaiDBA

13718043309

010-86462881

ORA-28534: Heterogeneous Services preprocessing error

1 个回答

相似问题