My Oracle Support Banner

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

Last updated on JUNE 15, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [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

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