MQSeries.net :: View topic

meetgaurav · Posted: Fri Sep 12, 2008 7:20 am Post subject:

Hi FJB SAPER

This time I came with a different issue

CREATE OR REPLACE PROCEDURE jmstext_enqueue(msg IN VARCHAR2)
AS

enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
agent sys.aq$_agent := sys.aq$_agent('test_agent', null, null);
message sys.aq$_jms_text_message;
recipients DBMS_AQ.aq$_recipient_list_t;

BEGIN
message := sys.aq$_jms_text_message.construct;
recipients(1) := sys.aq$_agent('test_agent', NULL, NULL);
message_properties.recipient_list := recipients;
message.set_string_property('color', 'RED');

message.set_text(msg);

dbms_aq.enqueue(queue_name => 'JMSDEMO_QUEUE',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message,
msgid => message_handle);
COMMIT;
END;

begin
jmstext_enqueue('SAMPLE MESSAGE');
end;

The above code is to enqueue the AQ Queue...If I create a Queue by multiple_consumers=>true.

exec dbms_aqadm.create_queue_table(queue_table=>'JMSDEMO_TABLE', queue_payload_type=>'sys.aq$_jms_text_message',multiple_consumers=>false);

I can able to Enqueue messages in the AQ by using above procedure. Suppose If create the Queue using multiple_consumers=>false.

Then I cant able to execute the above procedure. Not able to Enqueue the QUEUE..

Please assist me why I was not able to enqueue the Queue by using multiple_consumers=>false..