VERIFY_QUEUE_TYPES Returns Mismatch For RAW TYPE PAYLOADS
(Doc ID 2869762.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Setup Queue Propagation between two DB.
NLS_CHARACTERSET and NLS_LENGTH_SEMANTICS is set to same on both the source
and target databases
But when we create queue table at source and target with same payload RAW and
both are single consumer queue table.
When we execute DBMS_AQADM.VERIFY_QUEUE_TYPES it returns 0 value which
means not same
PL/SQL procedure successfully completed.
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