Advanced Queuing Propagation Fails with "ORA-22370: incorrect usage of method"

(Doc ID 1079577.1)

Last updated on NOVEMBER 04, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Advanced Queuing propagation fails between databases with the following error reported in the alert log:

Wed Jan 20 23:12:29 2010
Propagation Schedule for (STRMADMIN.OUT_Q, TARGET.WORLD) encountered following error:
ORA-22370: incorrect usage of method


In the trace file written by the job queue process (jnnn) that is attempting to run the associated queue schedule, there might be entries similar to the following:

ksedmp: internal or fatal error
ORA-22370: incorrect usage of method Higher version AnyData
Current SQL statement for this session:
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "STRMADMIN"."OUT_QT" tab where msgid = :1
----- PL/SQL Call Stack -----
object line object
handle number name
3fe8b83e0 7224 package body SYS.DBMS_AQADM_SYS
3fe8b83e0 7502 package body SYS.DBMS_AQADM_SYS
3fe8b2180 978 package body SYS.DBMS_AQADM
3fe8b8698 1 anonymous block
...
Call Stack Trace: ksedmp ksddoa ksdpcg ksdpec ksfpec kgesev kgesec1 kadgetembvalue kollScanAnyDataForLobs kollati kollScanImageForLobs kokegCollectGarbageFromImage kokegGarbageCollectOpn evaopn2 opifcr qertbFetchByRowID opifch2 kpoal8 opiodr kpoodrc rpiswu2 ...

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