Oracle | DBMS

Oracle DBMS_AQIN Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Provides secure access to Oracle Java Messaging Services (JMS) interfaces.

AUTHID CURRENT_USER

Dependencies

ANYDATA	AQ$_JMS_STREAMS_MESSAGE	DBMS_AQ
AQ$_AGENT	AQ$_JMS_TEXT_MESSAGE	DBMS_AQADM
AQ$_DUMMY_T	AQ$_RECIPIENTS	DBMS_AQADM_SYS
AQ$_JMS_BYTES_MESSAGE	AQ$_REG_INFO	DBMS_AQ_LIB
AQ$_JMS_MAP_MESSAGE	AQ$_REG_INFO_LIST	DBMS_STANDARD
AQ$_JMS_MESSAGE	AQ$_SIG_PROP	PLITBLM
AQ$_JMS_OBJECT_MESSAGE	AQ$_SUBSCRIBERS

Documented Only the security model is documented in the Types and Packages reference

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to the AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE, and EXECUTE_CATALOG_ROLE roles.

Source {ORACLE_HOME}/rdbms/admin/prvtaqji.plb

Subprograms

AQ$_ALTER_QUEUE	AQ$_ENQUEUE_RAW	AQ$_LISTEN
AQ$_CREATE_QUEUE	AQ$_ENQUEUE_RAW_NO_RECPL	AQ$_QUEUE_SUBSCRIBERS
AQ$_CREATE_QUEUE_TABLE	AQ$_GETBLOB_FROM_JMSANYDATA	AQ$_REGISTER_IN
AQ$_DEQUEUE_IN	AQ$_GETCLOB_FROM_JMSANYDATA	AQ$_START_QUEUE
AQ$_DEQUEUE_RAW	AQ$_JMS_ENQUEUE_BYTES_MESSAGE	AQ$_STOP_QUEUE
AQ$_DROP_QUEUE	AQ$_JMS_ENQUEUE_MAP_MESSAGE	GET_DEQ_SORT
AQ$_DROP_QUEUE_TABLE	AQ$_JMS_ENQUEUE_OBJECT_MESSAGE	GET_MULTI_RETRY
AQ$_ENQUEUE_OBJ	AQ$_JMS_ENQUEUE_STREAM_MESSAGE	SET_DEQ_SORT
AQ$_ENQUEUE_OBJ_NO_RECPL	AQ$_JMS_ENQUEUE_TEST_MESSAGE	SET_MULTI_RETRY

AQ$_ALTER_QUEUE

Undocumented dbms_aqin.aq$_alter_queue( queue_name IN VARCHAR2, max_retries IN NUMBER, retry_delay IN NUMBER, retention_time IN NUMBER, auto_commit IN BINARY_INTEGER);

TBD

AQ$_CREATE_QUEUE

Undocumented dbms_aqin.aq$_create_queue( queue_name IN VARCHAR2, queue_table IN VARCHAR2, queue_type IN BINARY_INTEGER, max_retries IN NUMBER, retry_delay IN NUMBER, retention_time IN NUMBER, dependency_tracking IN BINARY_INTEGER, comment IN VARCHAR2, auto_commit IN BINARY_INTEGER);

TBD

AQ$_CREATE_QUEUE_TABLE

Undocumented dbms_aqin.aq$_create_queue_table( queue_table IN VARCHAR2, queue_payload_type IN VARCHAR2, storage_clause IN VARCHAR2, sort_list IN VARCHAR2, multiple_consumers IN BINARY_INTEGER, message_grouping IN BINARY_INTEGER, comment IN VARCHAR2, auto_commit IN BINARY_INTEGER, primary_instance IN BINARY_INTEGER, secondary_instance IN BINARY_INTEGER, compatible IN VARCHAR2);

TBD

AQ$_DEQUEUE_IN

Undocumented
Overload 1 dbms_aqin.aq$_dequeue_in( queue_name IN VARCHAR2, subscriber IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, object_user_data OUT sys.standard<ADT_1>, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2);

TBD

Overload 2 dbms_aqin.aq$_dequeue_in( queue_name IN VARCHAR2, subscriber IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, object_user_data OUT sys.standard<ADT_1>, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER, OUT_delivery_mode OUT BINARY_INTEGER);

TBD

Overload 3 dbms_aqin.aq$_dequeue_in( queue_name IN VARCHAR2, subscriber IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, object_user_data OUT sys.standard<OPAQUE_1>, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2);

TBD

Overload 4 queue_name IN VARCHAR2, subscriber IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, object_user_data OUT sys.standard<OPAQUE_1>, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER, OUT_delivery_mode OUT BINARY_INTEGER);

TBD

Overload 5 dbms_aqin.aq$_dequeue_in( queue_name IN VARCHAR2, subscriber IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, object_user_data OUT sys.standard<ADT_1>);

TBD

AQ$_DEQUEUE_RAW

Undocumented

Overload 1 dbms_aqin.aq$_dequeue_raw( queue_name IN VARCHAR2, SUBSCRIBER IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2);

TBD

Overload 2 dbms_aqin.aq$_dequeue_raw( queue_name IN VARCHAR2, SUBSCRIBER IN VARCHAR2, msgid IN RAW, correlation IN VARCHAR2, dequeue_mode IN BINARY_INTEGER, navigation IN BINARY_INTEGER, visibility IN BINARY_INTEGER, wait IN BINARY_INTEGER, enqueue_time OUT DATE, state OUT BINARY_INTEGER, out_msgid OUT RAW, out_correlation OUT VARCHAR2, priority OUT BINARY_INTEGER, delay OUT BINARY_INTEGER, expiration OUT BINARY_INTEGER, attempts OUT BINARY_INTEGER, exception_queue OUT VARCHAR2, remote_recipients OUT sys.aq$_recipients, sender_name OUT VARCHAR2, sender_addr OUT VARCHAR2, sender_protocol OUT BINARY_INTEGER, original_msgid OUT RAW, payload_type IN BINARY_INTEGER, raw_user_data OUT RAW, deq_cond IN VARCHAR2, signature IN sys.aq$_sig_prop, out_sign OUT sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER, OUT_delivery_mode OUT BINARY_INTEGER);

TBD

AQ$_DROP_QUEUE

Undocumented dbms_aqin.aq$_drop_queue( queue_name IN VARCHAR2, auto_commit IN BINARY_INTEGER);

TBD

AQ$_DROP_QUEUE_TABLE

Undocumented dbms_aqin.aq$_drop_queue_table( queue_table IN VARCHAR2, FORCE IN BINARY_INTEGER, auto_commit IN BINARY_INTEGER);

TBD

AQ$_ENQUEUE_OBJ

Undocumented

Overload 1 dbms_aqin.aq$_enqueue_obj( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, OBJECT_USER_DATA IN sys.standard<ADT_1>, recipients IN sys.aq$_recipients, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER);

TBD

Overload 2 dbms_aqin.aq$_enqueue_obj( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, OBJECT_USER_DATA IN sys.standard<OPAQUE_1> recipients IN sys.aq$_recipients, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2 delivery_mode IN BINARY_INTEGER);

TBD

AQ$_ENQUEUE_OBJ_NO_RECPL

Undocumented
Overload 1 dbms_aqin.aq$_enqueue_obj_no_recpl( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, object_user_data IN sys.standard<ADT_1>, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER);

TBD

Overload 2 dbms_aqin.aq$_enqueue_obj_no_recpl( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, OBJECT_USER_DATA IN sys.standard<OPAQUE_1>, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2 delivery_mode IN BINARY_INTEGER);

TBD

AQ$_ENQUEUE_RAW

Undocumented dbms_aqin.aq$_enqueue_raw( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, OBJECT_USER_DATA IN sys.standard<ADT_1>, recipients IN sys.aq$_recipients, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_ENQUEUE_RAW_NO_RECPL

Undocumented dbms_aqin.aq$_enqueue_raw_no_recpl( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, msgid OUT RAW, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_GETBLOB_FROM_JMSANYDATA

Returns a ANYDATA data type message as a BLOB dbms_aqin.aq$_getblob_from_jmsanydata(ad IN sys.anydata) RETURN BLOB;

TBD

AQ$_GETCLOB_FROM_JMSANYDATA

Returns a ANYDATA data type message as a CLOB dbms_aqin.aq$_getclob_from_jmsanydata(ad IN sys.anydata) RETURN CLOB;

TBD

AQ$_JMS_ENQUEUE_BYTES_MESSAGE

Undocumented dbms_aqin.aq$_enqeue_bytes_message( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, bytes_message IN sys.aq$_jms_byte_message, recipients IN sys.aq$_recipients, msgid OUT RAW, gen_payload IN BINARY_INTEGER, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, create_new_lob IN BINARY_INTEGER, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_JMS_ENQUEUE_MAP_MESSAGE

Undocumented dbms_aqin.aq$_jms_enqueue_map_message( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, map_messae IN sys.aq$_jms_map_message, recipients IN sys.aq$_recipients, msgid OUT RAW, gen_payload IN BINARY_INTEGER, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, create_new_lob IN BINARY_INTEGER, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_JMS_ENQUEUE_OBJECT_MESSAGE

Undocumented dbms_aqin.aq$_jms_enqueue_object_message( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, object_message IN sys.aq$_jms_object_message, recipients IN sys.aq$_recipients, msgid OUT RAW, gen_payload IN BINARY_INTEGER, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, create_new_lob IN BINARY_INTEGER, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_JMS_ENQUEUE_STREAM_MESSAGE

Undocumented dbms_aqin.aq$_jms_enqueue_stream_message( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, stream_message IN sys.aq$_jms_stream_message, recipients IN sys.aq$_recipients, msgid OUT RAW, gen_payload IN BINARY_INTEGER, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, create_new_lob IN BINARY_INTEGER, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_JMS_ENQUEUE_TEXT_MESSAGE

Undocumented dbms_aqin.aq$_jms_enqueue_text_message( queue_name IN VARCHAR2, sender_name IN VARCHAR2, sender_addr IN VARCHAR2, sender_protocol IN BINARY_INTEGER, original_msgid IN RAW, correlation IN VARCHAR2, visibility IN BINARY_INTEGER, priority IN BINARY_INTEGER, delay IN BINARY_INTEGER, expiration IN BINARY_INTEGER, relative_msgid IN RAW, sequence_deviation IN BINARY_INTEGER, exception_queue IN VARCHAR2, payload_type IN BINARY_INTEGER, raw_user_data IN RAW, text_message IN sys.aq$_jms_text_message, recipients IN sys.aq$_recipients, msgid OUT RAW, gen_payload IN BINARY_INTEGER, signature IN sys.aq$_sig_prop, transformation IN VARCHAR2, create_new_lob IN BINARY_INTEGER, delivery_mode IN BINARY_INTEGER);

TBD

AQ$_LISTEN

Undocumented dbms_aqin.aq$_listen( AGENT_LIST IN sys.aq$_recipients, wait IN BINARY_INTEGER, AGENT OUT sys.aq$_agent);

TBD

AQ$_QUEUE_SUBSCRIBERS

Undocumented dbms_aqin.aq$_queue_subscribers( queue_name IN VARCHAR2, subs_list OUT sys.aq$_subscribers);

TBD

AQ$_REGISTER_IN

Undocumented dbms_aqin.aq$_register_in( NAME IN VARCHAR2, namespace IN NUMBER, callback IN VARCHAR2, context IN RAW);

TBD

AQ$_START_QUEUE

Undocumented dbms_aqin.aq$_start_queue( queue_name IN VARCHAR2, enqueue IN BINARY_INTEGER, dequeue IN BINARY_INTEGER);

TBD

AQ$_STOP_QUEUE

Undocumented dbms_aqin.aq$_stop_queue( queue_name IN VARCHAR2, enqueue IN BINARY_INTEGER, dequeue IN BINARY_INTEGER, wait IN BINARY_INTEGER);

TBD

GET_DEQ_SORT

Returns the dequeue sort value dbms_aqin.get_deq_sort RETURN BOOLEAN;

BEGIN

        IF dbms_aqin.get_deq_sort THEN

          dbms_output.put_line('Dequeue Sort Enabled');

        ELSE

          dbms_output.put_line('Dequeue Sort Disabled');

        END IF;

      END;

      /

GET_MULTI_RETRY

Returns the multi-retry value dbms_aqin.get_multi_retry RETURN BOOLEAN;

BEGIN

        IF dbms_aqin.get_multi_retry THEN

          dbms_output.put_line('Multi retry Enabled');

        ELSE

          dbms_output.put_line('Multi retry Disabled');

        END IF;

      END;

      /

SET_DEQ_SORT

If TRUE enables dequeue sorting dbms_aqin.set_deq_sort(state IN BOOLEAN);

exec dbms_aqin.set_deq_sort(TRUE);

SET_MULTI_RETRY

If TRUE enables multi retry dbms_aqin.set_multi_retry(state IN BOOLEAN);

exec dbms_aqin.set_multi_retry(TRUE);