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

ORA-31159: XML DB is in an invalid state

1 Answers  


NNO-00321: statistic counter dump disabled

1 Answers  


NCR-02007: NCRF: Invalid format descriptor received

1 Answers  


NNL-00902: ALIAS LOOP responses sent: number

1 Answers  


EXP-00073: dump file size too small

1 Answers  






RMAN-06040: controlfile is already restored to file string

1 Answers  


ORA-00072: process "string" is not active

1 Answers  


ORA-07446: sdnfy: bad value 'string' for parameter string.

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


LPX-00103: document structure does not match DTD

1 Answers  


ORA-25321: enqueue failed, user property specified but queue string.string is not an 8.1 style queue

1 Answers  


ORA-09300: osncon: unable to connect, DPMI not available

1 Answers  


Categories