5
DBMS_AQADM

The DBMS_AQADM package provides procedures to manage Advanced Queuing configuration and administration information.

See Also: Oracle9i Application Developer's Guide - Advanced Queuing contains information about using DBMS_AQADM.

This chapter discusses the following topics:

• Enumerated Constants

• Summary of DBMS_AQADM Subprograms

Enumerated Constants

When using enumerated constants, such as INFINITE, TRANSACTIONAL, or NORMAL_QUEUE, the symbol must be specified with the scope of the packages defining it. All types associated with the administrative interfaces must be prepended with DBMS_AQADM. For example: DBMS_AQADM.NORMAL_QUEUE.

Table 5-1 Enumerated Types in the Administrative Interface

Parameter	Options
retention	0,1,2...INFINITE
message_grouping	TRANSACTIONAL, NONE
queue_type	NORMAL_QUEUE, EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE

See Also: For more information on the Java classes and data structures used in both DBMS_AQ and DBMS_AQADM, see Chapter 4, "DBMS_AQ"

Summary of DBMS_AQADM Subprograms

Table 5-2 DBMS_AQADM Package Subprograms  

Subprogram	Description
"CREATE_QUEUE_TABLE Procedure"	Creates a queue table for messages of a predefined type.
"ALTER_QUEUE_TABLE Procedure"	Alters an existing queue table.
"DROP_QUEUE_TABLE Procedure"	Drops an existing queue table.
"CREATE_QUEUE Procedure"	Creates a queue in the specified queue table.
"CREATE_NP_QUEUE Procedure"	Creates a nonpersistent RAW queue.
"ALTER_QUEUE Procedure"	Alters existing properties of a queue.
"DROP_QUEUE Procedure"	Drops an existing queue.
"START_QUEUE Procedure"	Enables the specified queue for enqueuing and/or dequeueing.
"STOP_QUEUE Procedure"	Disables enqueuing and/or dequeuing on the specified queue.
"GRANT_SYSTEM_PRIVILEGE Procedure"	Grants AQ system privileges to users and roles.
"REVOKE_SYSTEM_PRIVILEGE Procedure"	Revokes AQ system privileges from users and roles.
"GRANT_QUEUE_PRIVILEGE Procedure"	Grants privileges on a queue to users and roles.
"REVOKE_QUEUE_PRIVILEGE Procedure"	Revokes privileges on a queue from users and roles.
"ADD_SUBSCRIBER Procedure"	Adds a default subscriber to a queue.
"ALTER_SUBSCRIBER Procedure"	Alters existing properties of a subscriber to a specified queue.
"REMOVE_SUBSCRIBER Procedure"	Removes a default subscriber from a queue.
"SCHEDULE_PROPAGATION Procedure"	Schedules propagation of messages from a queue to a destination identified by a specific dblink.
"UNSCHEDULE_PROPAGATION Procedure"	Unschedules previously scheduled propagation of messages from a queue to a destination identified by a specific dblink.
"VERIFY_QUEUE_TYPES Procedure"	Verifies that the source and destination queues have identical types.
"ALTER_PROPAGATION_SCHEDULE Procedure"	Alters parameters for a propagation schedule.
"ENABLE_PROPAGATION_SCHEDULE Procedure"	Enables a previously disabled propagation schedule.
"DISABLE_PROPAGATION_SCHEDULE Procedure"	Disables a propagation schedule.
"MIGRATE_QUEUE_TABLE Procedure"	Upgrades an 8.0-compatible queue table to an 8.1-compatible queue table, or downgrades an 8.1-compatible queue table to an 8.0-compatible queue table.
"CREATE_AQ_AGENT Procedure"	Registers a agent for AQ Internet access
"ALTER_AQ_AGENT Procedure"	Alters a agent registered for AQ Internet access
"DROP_AQ_AGENT Procedure"	Drops a agent registered for AQ Internet access
"ENABLE_DB_ACCESS Procedure"	Grants an AQ Internet agent the privileges of a specific database user
"DISABLE_DB_ACCESS Procedure"	Revokes the privileges of a database user from an AQ Internet agent
"ADD_ALIAS_TO_LDAP Procedure"	Creates an alias for a queue, agent, or a JMS ConnectionFactory in LDAP.
"DEL_ALIAS_FROM_LDAP Procedure"	Drops an alias for a queue, agent, or JMS ConnectionFactory in LDAP.