REGISTER v11
Use the REGISTER
procedure to register an email address, procedure or URL that will be notified when an item is enqueued or dequeued. The signature is:
Parameters
reg_list
is a list of type AQ$_REG_INFO_LIST
; that provides information about each subscription that you would like to register. Each entry within the list is of the type AQ$_REG_INFO
, and may contain:
Attribute | Type | Description |
---|---|---|
name | VARCHAR2 (128) | The (optionally schema-qualified) name of the subscription. |
namespace | NUMERIC | The only supported value is DBMS_AQ.NAMESPACE_AQ (0) |
callback | VARCHAR2 (4000) | Describes the action that will be performed upon notification. Currently, only calls to PL/SQL procedures are supported. The call should take the form:plsql://schema.procedure Where: schema specifies the schema in which the procedure resides. procedure specifies the name of the procedure that will be notified. |
context | RAW (16) | Any user-defined value required by the procedure. |
count
count
is the number of entries in reg_list
.
Example
The following anonymous block calls DBMS_AQ.REGISTER
, registering procedures that will be notified when an item is added to or removed from a queue. A set of attributes (of sys.aq$_reg_info
type) is provided for each subscription identified in the DECLARE
section:
The subscriptionlist
is of type sys.aq$_reg_info_list
, and contains the previously described sys.aq$_reg_info
objects. The list name and an object count are passed to dbms_aq.register
.