"user_data type and queue type do not match"
Please help me solve this problem.
BEGIN
DBMS_AQADM.STOP_QUEUE (
queue_name => 'XXIO_I00');
DBMS_AQADM.DROP_QUEUE (
queue_name => 'XXIO_I00');
DBMS_AQADM.DROP_QUEUE_TABLE (
queue_table => 'XXIO_I00');
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table => 'XXIO_I00',
queue_payload_type => 'sys.aq$_jms_text_message',
multiple_consumers => TRUE);
DBMS_AQADM.CREATE_QUEUE(
queue_name => 'XXIO_I00',
queue_table => 'XXIO_I00',
queue_type => sys.dbms_aqadm.normal_queue
);
DBMS_AQADM.START_QUEUE(
queue_name => 'XXIO_I00');
dbms_aqadm.grant_queue_privilege('DEQUEUE', 'XXIO_I00', 'aquser', FALSE);
DECLARE
subscriber sys.aq$_agent;
BEGIN
subscriber := sys.aq$_agent('aquser', NULL, NULL);
dbms_aqadm.add_subscriber(queue_name => 'XXIO_I00',
subscriber => subscriber);
declare
l_message clob := '';
v_enqueue_options dbms_aq.enqueue_options_t;
v_msg_props dbms_aq.message_properties_t;
v_msg_id RAW(16);
v_message SYS.AQ$_JMS_MESSAGE := SYS.AQ$_JMS_MESSAGE.construct(DBMS_AQ.JMS_TEXT_MESSAGE);
begin
l_message := '<ns4:elements xmlns:ns4="http://ns.thisisahmed.com/MyMessage/20080702"><ns4:element><ns4:firstname>Ahmed</ns4:firstname><ns4:lastname>Naga</ns4:lastname></ns4:element></ns4:elements>';
v_message.set_text(xmltype(l_message).getstringval());
dbms_aq.enqueue(queue_name => 'XXIO_I00',
enqueue_options => v_enqueue_options,
message_properties => v_msg_props,
payload => v_message,
msgid => v_msg_id);
commit;
END;
END;
END;
/
Error report:
ORA-25215: user_data-typ och kötyp matchar inte
ORA-06512: vid "SYS.DBMS_AQ", rad 169
ORA-06512: vid rad 52
25215. 00000 - "user_data type and queue type do not match"
*Cause: A user tries to enqueue an object to a queue that was
created for objects of different type.
*Action: Try enqueue again with an object of the right type.