GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ORA-22370:INCORRECT USUAGE OF METHOD

edited Jun 26, 2018 9:54AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi,

We have DB link based Oracle AQ interface between two different 10G systems having same character set. Within these two,one is getting upgraded to 11G and while testing the AQ interface between 11G to10G we  have faced  an error ‘ORA-22370:INCORRECT USUAGE OF METHOD’
Can anyone help us to find solution for this.

The script for OUT_MESSAGE_QUEUE and OUT_MESSAGE_TABLE is as below:

--OUT queue script

BEGIN
  SYS.DBMS_AQADM.STOP_QUEUE ( QUEUE_NAME => 'AQADM.OUT_MESSAGE_QUEUE');
  SYS.DBMS_AQADM.DROP_QUEUE ( QUEUE_NAME => 'AQADM.OUT_MESSAGE_QUEUE');
END;
/

BEGIN
  SYS.DBMS_AQADM.CREATE_QUEUE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center