Oracle AQ Topic Queue dequeue with ODP.NET
Problem solved! I missed to create on my own the subscriber by the following script:
declare vQueue varchar2(255) := '<TOPIC_QUEUE_ID>'; vId varchar2(255) := 'Test_Subscriber_ID'; vSubscriber SYS.AQ$_AGENT;begin vSubscriber := SYS.AQ$_AGENT(vId, null, null); dbms_aqadm.add_subscriber( queue_name => vQueue, subscriber => vSubscriber, queue_to_queue => false, delivery_mode => DBMS_AQADM.PERSISTENT ); /*dbms_aqadm.enable_db_access( agent_name => vId, db_username => '<USER_ID>' );*/end;
With J2EE the subscriber creation is automatic!
Many thanks,Antonio