ORA-28534: Heterogeneous Services preprocessing error



ORA-28534: Heterogeneous Services preprocessing error..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08162: executing Memory Script

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  


LPX-00019: property "~s" unknown

1 Answers  


PLS-01908: : RETURNING INTO buffer too small

1 Answers  


ORA-24314: service handle not initialized

1 Answers  


QSM-00789: the string string is invalid for directive string

1 Answers  


QSM-02121: set operator in a context not supported for fast refresh

1 Answers  


NZE-28822: Required seed is not specified.

1 Answers  


NNL-00348: Server saving the config file now

1 Answers  


ORA-10564: tablespace string

1 Answers  


PCC-01102: Invalid label at line number in file string

1 Answers  


ORA-02468: Constant or system variable wrongly specified in expression

1 Answers  


Categories