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 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 |