Error in procedure
970843Dec 26 2012 — edited Dec 27 2012Hi,
Below is my procedure to enqueue data in a queue, while running the procedure i am getting compilation errors, i cant find where i went wrong.please help me with solution.
CREATE OR REPLACE PROCEDURE p_enqueue(msg IN VARCHAR2)
AS
PRAGMA AUTONOMOUS_TRANSACTION;
enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
BEGIN
dbms_aq.enqueue( queue_name => 'example_queue',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message_type(msg),
msgid => message_handle);
COMMIT;
END;
ERRORS:
PLS-00201: identifier 'DBMS_AQ' must be declared
PLS-00320: the declaration of the type of this expression is incomplete or malformed