Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

4
DBMS_AQ

The DBMS_AQ package provides an interface to Oracle's Advanced Queuing.

See Also:

Oracle9i Application Developer's Guide - Advanced Queuing contains information about using DBMS_AQ

Java Classes

Java interfaces are available for DBMS_AQ and DBMS_AQADM. The Java interfaces are provided in the $ORACLE_HOME/rdbms/jlib/aqapi.jar. Users are required to have EXECUTE privileges on the DBMS_AQIN package to use these interfaces.

Enumerated Constants

When using enumerated constants such as BROWSE, LOCKED, or REMOVE, the PL/SQL constants must be specified with the scope of the packages defining it. All types associated with the operational interfaces have to be prepended with DBMS_AQ. For example: DBMS_AQ.BROWSE.

Table 4-1 Enumerated Constants
Parameter  Options 
visibility
 
IMMEDIATE, ON_COMMIT
 
dequeue mode
 
BROWSE, LOCKED, REMOVE, REMOVE_NODATA
 
navigation
 
FIRST_MESSAGE, NEXT_MESSAGE, NEXT_TRANSACTION
 
state
 
WAITING, READY, PROCESSED, EXPIRED
 
sequence_deviation
 
BEFORE, TOP
 
wait
 
FOREVER, NO_WAIT
 
delay
 
NO_DELAY
 
expiration
 
NEVER
 
namespace
 
NAMESPACE_AQ, NAMESPACE_ANONYMOUS
 

Data Structures for DBMS_AQ

Table 4-2 lists the data structures used in both DBMS_AQ and DBMS_AQADM.

Table 4-2 Data structures in DBMS_AQ and DBMS_AQDM  
Data Structures 

"Object Name" 

"Type Name" 

"Agent" 

"Enqueue Options Type" 

"Dequeue Options Type" 

"Message Properties Type" 

"AQ Recipient List Type" 

"AQ Agent List Type" 

"AQ Subscriber List Type" 

"AQ Registration Info Type" 

"AQ Registration Info List Type" 

"AQ Notification Descriptor Type" 

"AQ Post Info Type" 

"AQ Post Info List Type" 

"AQ PL/SQL Callback" 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback