ORA-22370:INCORRECT USUAGE OF METHOD
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