Enable_db_access is a procedure that grants
AQ Internet agent privileges to a specified
database user.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
AGENT_NAME
|
VARCHAR2
|
IN
|
|
|
DB_USERNAME
|
VARCHAR2
|
IN
|
|
Table 6.76:
Enable_db_access Parameters
Enable_jms_types is a procedure that when
called after
set_up_queue,
permits SYS.ANYDATA streams work for JMS types
and XML types.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
Table 6.77:
Enable_jms_types Parameter
Enable_propagation_schedule is
a procedure that enables a propagation schedule.
If the destination parameter for the destination
database link is NULL, then the destination is
the local database and all messages are
propagated to other local database queues.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
DESTINATION
|
VARCHAR2
|
IN
|
NULL
|
|
DESTINATION_QUEUE
|
VARCHAR2
|
IN
|
NULL
|
Table 6.78:
Enable_propagation_schedule Parameters
Get_watermark is a procedure that returns
the watermark value in megabytes set by
set_watermark.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
WMVALUE
|
NUMBER
|
OUT
|
|
Table 6.79:
Get_watermark Parameter
Grant_queue_privilege is a procedure for
granting regular queue privileges to database
users and roles. The
privilege parameter access the following:
ALL, ENQUEUE, and DEQUEUE.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PRIVILEGE
|
VARCHAR2
|
IN
|
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
GRANTEE
|
VARCHAR2
|
IN
|
|
|
GRANT_OPTION
|
BOOLEAN
|
IN
|
FALSE
|
Table 6.80:
Grant_queue_privilege Parameters
Grant_system_privilege is a procedure for
granting special queue privileges to database
users and roles. The privilege parameter
accesses the following: MANAGE_ANY, ENQUEUE_ANY,
and DEQUEUE_ANY.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PRIVILEGE
|
VARCHAR2
|
IN
|
|
|
GRANTEE
|
VARCHAR2
|
IN
|
|
|
GRANT_OPTION
|
BOOLEAN
|
IN
|
FALSE
|
Table 6.81:
Grant_system_privilege Parameters
Migrate_queue_table is a procedure for
upgrading and downgrading queue tables between
Oracle 8.0 and 8.1 compatible formats. Note that
these are the two permissible values for the
compatible parameter.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
COMPATIBLE
|
VARCHAR2
|
IN
|
|
Table 6.82:
Migrate_queue_table Parameters
Purge_queue_table is a procedure that
purges queue table messages, plus it generates a
trace file in user_dump_dest that
details what the procedure did. The
purge_options parameter requires using the
special purge record type shown just below. When
BLOCK=TRUE, then an exclusive lock is held on
all queues within that queue table during the
purge.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
PURGE_CONDITION
|
VARCHAR2
|
IN
|
|
|
PURGE_OPTIONS
|
AQ$_PURGE_OPTION_T
|
IN
|
|
Table 6.83:
Purge_queue_table Parameters
TYPE aq$_purge_options_t
IS RECORD(
block
boolean
DEFAULT FALSE,
delivery_mode
PLS_INTEGER
DEFAULT dbms_aqadm.PERSISTENT
);
Remove_subscriber is a procedure that
simply drops a subscriber from a queue. It takes
immediate effect, i.e. is committed.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
SUBSCRIBER
|
SYS.AQ$_AGENT
|
IN
|
|
Table 6.84:
Remove_subscriber Parameters
Revoke_queue_privilege is a procedure for
revoking regular queue privileges from database
users and roles. The privilege parameter
accesses the following: ALL, ENQUEUE, and
DEQUEUE.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PRIVILEGE
|
VARCHAR2
|
IN
|
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
GRANTEE
|
VARCHAR2
|
IN
|
|
Table 6.85:
Revoke_queue_privilege Parameters
Revoke_system_privilege is a procedure for
revoking special queue privileges from database
users and roles. The privilege parameter
accesses the following: MANAGE_ANY, ENQUEUE_ANY,
and DEQUEUE_ANY.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PRIVILEGE
|
VARCHAR2
|
IN
|
|
|
GRANTEE
|
VARCHAR2
|
IN
|
|
Table 6.86:
Revoke_system_privilege Parameters
Schedule_Propagation is a procedure that
defines a propagation schedule. If the
destination
parameter for the destination database link is
NULL, then the destination is the local database
and all messages are propagated to other local
database queues.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
DESTINATION
|
VARCHAR2
|
IN
|
NULL
|
|
START_TIME
|
DATE
|
IN
|
SYSDATE
|
|
DURATION
|
NUMBER
|
IN
|
NULL
|
|
NEXT_TIME
|
VARCHAR2
|
IN
|
NULL
|
|
LATENCY
|
NUMBER
|
IN
|
60
|
|
DESTINATION_QUEUE
|
VARCHAR2
|
IN
|
NULL
|
Table 6.87:
Schedule_propagation Parameters
Set_watermark is a procedure that defines
the watermark value in megabytes, which is used
to control and/or limit memory use.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
WMVALUE
|
NUMBER
|
OUT
|
|
Table 6.88:
Set_watermark Parameter
Start_queue is a procedure that enables
enqueuing and dequeuing for the specified queue.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
ENQUEUE
|
BOLLEAN
|
IN
|
TRUE
|
|
DEQUEUE
|
BOOLEAN
|
IN
|
TRUE
|
Table 6.89:
Start_queue Parameters
Stop_queue is a procedure that disables
enqueuing and dequeuing for the specified queue.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
ENQUEUE
|
BOLLEAN
|
IN
|
TRUE
|
|
DEQUEUE
|
BOOLEAN
|
IN
|
TRUE
|
Table 6.90:
Stop_queue Parameters
Unschedule_Propagation is a procedure that
undefines a propagation schedule. If the
destination parameter for the destination
database link is NULL, then the destination is
the local database and all messages are
propagated to other local database queues.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
DESTINATION
|
VARCHAR2
|
IN
|
NULL
|
|
DESTINATION_QUEUE
|
VARCHAR2
|
IN
|
NULL
|
Table 6.91:
Unschedule_propagation Parameters
