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

TNS-00306: Connection Manager encountered an invalid/unknown trace level

1 Answers  


ORA-10661: Invalid option specified

1 Answers  


NNO-00306: server shutdown countdown aborted

1 Answers  


ORA-35276: (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]

1 Answers  


DRG-10573: index string is obsolete

1 Answers  






PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-25264: cant get signature for this queue

1 Answers  


ORA-27002: function called with invalid device structure

1 Answers  


ORA-19572: cannot process file string, file is being being resized

1 Answers  


PROC-00032: Cluster Ready Services on the local node is not running

1 Answers  


ORA-22614: error while construction the collection in the image

1 Answers  


ORA-01588: must use RESETLOGS option for database open

1 Answers  


Categories