HELP! ORA-25215: user_data type and queue type do not match
I created a queue with the below script
I also registered it in the application
But sending messages to it gets this error
Error Name = -25215
Error Message = ORA-25215: user_data type and queue type do not match
Error Stack =
WF_EVENT_OJMSTEXT_QH.enqueue(XXMC.XXMC_DS_JMS_OUT, SQL error is ORA-25215: user_data type and queue type do not match)
Wf_Event.Enqueue(oracle.apps.ar.hz.CustAcctSite.update, WF_EVENT_OJMSTEXT_QH)
Wf_Event.Send(oracle.apps.ar.hz.CustAcctSite.update)
Wf_Engine_Util.Event_Activity(XXMCACST, oracle.apps.ar.hz.CustAcctSite.update46477, 168618, RUN)
Why is that? The trading partners in xml gateway are set up fine!
What gives?
Any help would be appreciated!
-Jason
QUEUE SCRIPT:
=================================================
declare
queue_table_exists exception;
pragma EXCEPTION_INIT(queue_table_exists, -24001);
begin
dbms_output.put_line('===================================');
dbms_output.put_line('Creating Queue Table for XXMC.XXMC_DS_JMS_OUT Queue ');
dbms_output.put_line('===================================');
begin
dbms_aqadm.create_queue_table
(
queue_table => 'XXMC.XXMC_DS_JMS_OUT',
queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE',
sort_list => 'PRIORITY,ENQ_TIME',
multiple_consumers => FALSE,
comment => 'Custom JMS Topic',
compatible => '8.1'
);
exception
when queue_table_exists then
null;
when others then
dbms_output.put_line('Oracle Server Error = '||to_char(sqlcode));
dbms_output.put_line('Oracle Server Message = '||SQLERRM);
raise_application_error(-20000, 'Oracle Error Mkr2= '||to_char(sqlcode)||' - '||sqlerrm);
end;
end;
/
=====================================================