ORA-22370 reported on Propagating Message payloads within an ANYDATA type
(Doc ID 365262.1)
Last updated on MARCH 05, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
Using Advanced Queueing (AQ) propagation to propagate user enqueued events between databases with different charactersets.
When the message payload of the queue table is defined as SYS.ANYDATA the following errors are reported in the source database alert log file:
ORA-00604: error occurred at recursive SQL level 1
ORA-22370: incorrect usage of method Charset:Import
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document