multiconsumer Queue with an Oracle Type from Java

You have a multi consumer queue with a user defined type CREATE TYPE topic_message AS OBJECT(Subject VARCHAR2(30),Text VARCHAR2(80)) / BEGIN dbms_aqadm.create_queue_table( ‘topic_queue_table’, ‘topic_message’, Multiple_consumers=>TRUE); dbms_aqadm.create_queue( ‘toy_topic’, ‘topic_queue_table’); dbms_aqadm.start_queue( ‘toy_topic’); END; / You create the corresponding java class with JPublisher (check the documentation of Database JPublisher User’s Guide 12c Release 1 (12.1) from which I took […]