My Oracle Support Banner

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 9.2.0.1 to 11.1.0.6 [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.

Symptoms

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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.