VERIFY_QUEUE_TYPES Returns Mismatch For RAW TYPE PAYLOADS (Doc ID 2869762.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

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.

Changes

Cause

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