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-22954: This multiset operation is not supported for this element type.

1 Answers  


ORA-30571: invalid SEGMENT SPACE MANAGEMENT clause

2 Answers  


ORA-38740: Usable blocks value string is not valid.

1 Answers  


ORA-24101: stopped processing the argument list at: string

1 Answers  


ORA-24418: Cannot open further sessions.

1 Answers  


SQL*Loader-00905: Error parsing SQL statement for upi: [number]

1 Answers  


ORA-22887: type of REF column is not the same as that of its scoped table

1 Answers  


ORA-31640: unable to open dump file "string" for read

1 Answers  


ORA-13188: cell decode failed

1 Answers  


ORA-01614: instance string (thread string) is busy - cannot enable

1 Answers  


ORA-24032: object string exists, index could not be created for queue table string

1 Answers  


PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable

1 Answers  


Categories