EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE('FROMQTAB','FILE_T');
--FILE_T是我自己建的一个TYPE
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE('TOQTAB','FILE_T');
EXECUTE DBMS_AQADM.CREATE_QUEUE('FROMQ','FROMQTAB');
EXECUTE DBMS_AQADM.CREATE_QUEUE('TOQ','TOQTAB');
然后，我使用
EXECUTE DBMS_AQADM.START_QUEUE('FROMQ');
EXECUTE DBMS_AQADM.ENABLE_PROPAGATION_SCHEDULE('FROMQ','TO_INEWDB');
--TO_INEWDB是我自己建立的一个DBLINK。是可以连接的。
EXECUTE DBMS_AQADM.SCHEDULE_PROPAGATION('FROMQ','TO_INEWDB',SYSDATE,30,NULL,0);
当我使用SCHEDULE_PROPAGATION时出错
ORA-24039
在ORACLE的HELP里，我查到：
ORA-24039 Queue string not created in queue table for multiple consumers
Cause: Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_SUBSCRIBER procedure, or an ENQUEUE with a non-empty recipient list, was issued on a queue that was not created for multiple consumers.
Action: Create the queue in a queue table that was created for multiple consumers and retry the call.
请问，有谁碰到过这种问题吗？如何解决？
