Database Administration (MOSC)

MOSC Banner

ORA-22370: incorrect usage of method

edited Oct 16, 2015 10:00AM in Database Administration (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