Alter_subscriber
is a procedure that
modifies a queue subscriber’s properties. The
rule parameter is a conditional expression
string much like a WHERE clause, and must be
properly (double) quoted. Note that this
procedure permits altering both the rule and the
transformation. If one wants to retain the
existing value for either of them, specify the
old value.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
SUBSCRIBER
|
SYS.AQ$_AGENT
|
IN
|
|
|
RULE
|
VARCHAR2
|
IN
|
|
|
TRANSFORMATION
|
VARCHAR2
|
IN
|
|
Table 6.65:
Alter_subscriber Parameters
Create_aq_agent is a procedure that creates
an AQ agent’s registration for internet access.
However, for access through HTTP, the
certificate location is not required.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
AGENT_NAME
|
VARCHAR2
|
IN
|
|
|
CERTIFICATE_LOCATION
|
VARCHAR2
|
IN
|
NULL
|
|
ENABLE_HTTP
|
BOOLEAN
|
IN
|
FALSE
|
|
ENABLE_SMTP
|
BOOLEAN
|
IN
|
FALSE
|
|
ENABLE_ANYP
|
BOOELAN
|
IN
|
FALSE
|
Table 6.66:
Create_aq_agent Parameters
Create_np_queue is a procedure that creates
a non-persistent RAW queue which has been
deprecated as of Oracle 10gR2, so use buffered
messaging instead.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE
|
VARCHAR2
|
IN
|
|
|
MULTIPLE_CONSUMERS
|
BOOLEAN
|
IN
|
FALSE
|
|
COMMENT
|
VARCHAR2
|
IN
|
NULL
|
Table 6.67:
Create_np_queue Parameters
Create_queue
is a procedure that creates a message queue
within the specified queue table. Note that a
message is automatically transferred to an
exception queue if retry_count >max_retries.
Retry count. Also note that the
auto_commit parameter has been deprecated.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
QUEUE_TYPE
|
BINARY_INTEGER
|
IN
|
NORMAL_QUEUE
|
|
MAX_RETRIES
|
NUMBER
|
IN
|
NULL
|
|
RETRY_DELAY
|
NUMBER
|
IN
|
0
|
|
RETENTION_TIME
|
NUMBER
|
IN
|
0
|
|
DEPENDENCY_TRACKING
|
BOOLEAN
|
IN
|
FALSE
|
|
COMMENT
|
VARCHAR2
|
IN
|
NULL
|
|
AUTO_COMMIT
|
BOOLEAN
|
IN
|
TRUE
|
Table 6.68:
Create_queue Parameters
Create_queue_table is a procedure that
creates a queue table of a predefined message
type. The
storage_clause
parameter takes the same text as in a standard
CREATE TABLE storage clause. The primary
instance performs the monitor scheduling and
propagation for the queues in the queue table.
The secondary instance is strictly for failover,
as when the primary instance is unavailable.
Also note that the auto_commit
parameter has been deprecated.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
QUEUE_PAYLOAD_TYPE
|
VARCHAR2
|
IN
|
|
|
STORAGE_CLAUSE
|
VARCHAR2
|
IN
|
NULL
|
|
SORT_LIST
|
VARCHAR2
|
IN
|
NULL
|
|
MULTIPLE_CONSUMERS
|
BOOLEAN
|
IN
|
FALSE
|
|
MESSAGE_LOGGING
|
BINARY_INTEGER
|
IN
|
NONE
|
|
COMMENT
|
VARCHAR2
|
IN
|
NULL
|
|
AUTO_COMMIT
|
BOOLEAN
|
IN
|
TRUE
|
|
PRIMARY_INSTANCE
|
BINARY_INTEGER
|
IN
|
0
|
|
SECONDARY_INSTANCE
|
BINARY_INTEGER
|
IN
|
0
|
|
COMPATTIBLE
|
VARCHAR2
|
IN
|
NULL
|
|
SECURE
|
BOOLEAN
|
IN
|
FALSE
|
Table 6.69:
Create_queue_table Parameters
Del_alias_from_ldap is a procedure that
drops an alias for an object, i.e. queue, agent
or connection factory.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
ALIAS
|
VARCHAR2
|
IN
|
|
Table 6.70:
Del_alias_from_ldap Parameters
Disable_db_access is a procedure that
revokes AQ Internet agent privileges from a
specified database user.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
AGENT_NAME
|
VARCHAR2
|
IN
|
|
|
DB_USERNAME
|
VARCHAR2
|
IN
|
|
Table 6.71:
Disable_db_access Parameters
Disable_propagation_schedule is a procedure
that disables 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.72:
Disable_propagation_schedule Parameters
Drop_aq_agent is a procedure that drops an
AQ agent’s registration for internet access.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
AGENT_NAME
|
VARCHAR2
|
IN
|
|
Table 6.73:
Drop_aq_agent
Parameter
Drop_queue is a procedure that drops a
message queue. Note that the auto_commit
parameter has been deprecated. Also remember to
first call stop_queue.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_NAME
|
VARCHAR2
|
IN
|
|
|
AUTO_COMMIT
|
BOOLEAN
|
IN
|
TRUE
|
Table 6.74:
Drop_queue
Parameters
Drop_queue_table is a procedure that drops
a queue table. The force parameter controls
whether a queue table containing queues can be
dropped. Note that the auto_commit
parameter has been deprecated.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
QUEUE_TABLE
|
VARCHAR2
|
IN
|
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
|
AUTO_COMMIT
|
BOOLEAN
|
IN
|
TRUE
|
Table 6.75:
Drop_queue_table Parameters
