Oracle Database Discussions

Hi All,

I am trying to create a Queue and En-queue a message but I am getting error while en-queue a message as,

"*ERROR at line 10:*
*ORA-06550: line 10, column 3:*
*PLS-00306: wrong number or types of arguments in call to 'ENQUEUE'*
*ORA-06550: line 10, column 3:*
*PL/SQL: Statement ignored*"


I am using oracle 11g R2. Below is the script, user mthiiora1 has AQ ADMIN privilege,

CREATE TYPE mthiiora1.mt_ora1_q_type1 AS OBJECT (message_id NUMBER,
message_text VARCHAR2(4000));


BEGIN
-- Creating Queue Table
DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'mt_ora1_q_type1_t1',
queue_payload_type => 'mthiiora1.mt_ora1_q_type1');
-- Creating Queue
DBMS_AQADM.create_queue (queue_name => 'mt_ora1_que1',
queue_table => 'mt_ora1_q_type1_t1');
-- Starting Queue
DBMS_AQADM.start_queue (queue_name => 'mt_ora1_que1',
enqueue => TRUE);
END;


DECLARE
laq_queue_options DBMS_AQ.ENQUEUE_OPTIONS_T;
laq_message_properties DBMS_AQ.MESSAGE_PROPERTIES_T;
laq_message_id RAW(32);
laq_message mthiiora1.mt_ora1_q_type1;
BEGIN
laq_message := mthiiora1.mt_ora1_q_type1(1, 'Message 1');

DBMS_AQ.enqueue ( queue_name => 'mt_ora1_que1',
enqueue_options => laq_queue_options,
message_properties => laq_message_properties,
pay_load => laq_message,
msgid => laq_message_id);

COMMIT;
END;
*/*

Could you anyone please help me to resolve this issue?