ORA-22370 reported on Propagating Message payloads within an ANYDATA type (Doc ID 365262.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1.0 to 11.1.0.6.0
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms