Oracle PL/SQL Language Pocket Reference- P28: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. . | The Oracle Library Navigation Copyright c 2000 O Reilly Associates. All rights reserved. Please purchase PDF Split-Merge on to remove this watermark. Next DBMS_DDL Previous DBMS_ALERT Appendix C Built-In Packages Oracle AQ the Advanced Queueing Facility Oracle8 offers the Oracle Advanced Queuing facility Oracle AQ which implements deferred execution of work. There are two packages you will use to implement advanced queuing DBMS_AQ which contains the queuing procedures themselves and DBMS_AQADM which lets you perform administrative tasks. They make extensive use of PL SQL record structures as you will see in the individual program interfaces below. For more detail on these records and how to manipulate their contents see Oracle Built-in Packages. DBMS_AQ PL SQL 8 Only The DBMS_AQ package provides an interface to the messaging tasks of Oracle AQ. To use these procedures you must have been granted the new role AQ_USER_ROLE. The ENQUEUE procedure The ENQUEUE procedure adds a message to an existing message queue. The target message queue must have had enqueuing enabled previously via the DBMS_ procedure. The specification is PROCEDURE q_schema IN VARCHAR2 DEFAULT NULL q_name IN VARCHAR2 corrid IN VARCHAR2 DEFAULT NULL transactional IN BOOLEAN TRUE priority IN POSITIVE DEFAULT 1 delay IN DATE DEFAULT NULL expiration IN NATURAL 0 relative_msgid IN NUMBER DEFAULT NULL seq_deviation IN CHAR DEFAULT A exception_queue_schema IN VARCHAR2 DEFAULT NULL exception_queue IN VARCHAR2 DEFAULT NULL Please purchase PDF Split-Merge on to remove this watermark. reply_queue_schema IN VARCHAR2 DEFAULT NULL reply_queue IN VARCHAR2 DEFAULT NULL user_data IN any_object_type msgid OUT RAW The DEQUEUE procedure The DEQUEUE procedure can either remove or browse a message from an existing message queue. The target message queue must have had dequeuing enabled previously via the DBMS_AQADM. .
