Oracle De-Queue Message Error
When I try to do the Oracle AQ message de-queue, there are error message below, would someone help?
with many thanks,
Script:
set serveroutput on
declare
err_count pls_integer := 0;
deq_count pls_integer := 0;
stat_count pls_integer := 0;
clob_count pls_integer := 0;
merr_count pls_integer := 0;
qupd_count pls_integer := 0;
deq_options dbms_aq.dequeue_options_t;
deq_msg_properties dbms_aq.message_properties_t;
deq_message xmlqmessage_type;
deq_msg_handle raw(16);
stat_action_id int_upload_status.be.action_instance_id%type;
stat_module_name int_upload_status.be.modulename%type;
cursor cur_oq_messages is
select q.queue, q.consumer_name, q.msg_id, q.user_data.resort