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-26077: direct path column array is not initialized

0 Answers  


ORA-00741: logfile size of (string) blocks exceeds maximum logfile size

1 Answers  


ORA-12574: TNS:redirection denied

1 Answers  


ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

1 Answers  


EXP-00090: cannot pin type "string"."string"

1 Answers  






ORA-30751: cannot disable column string from storing objects of type string.string

1 Answers  


DRG-12438: document table release failed

1 Answers  


RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

1 Answers  


ORA-31449: invalid value for change_set_name

1 Answers  


ORA-29828: invalid name for implementation type

1 Answers  


ORA-02473: Error while evaluating the cluster's hash expression.

1 Answers  


LSX-00160: invalid substitution group affiliation between "~S" and "~S"

1 Answers  


Categories