UNREGISTER v14
Use the UNREGISTER procedure to turn off notifications related to enqueueing and dequeueing. The signature is:
UNREGISTER( <reg_list> IN SYS.AQ$_REG_INFO_LIST, <count> IN NUMBER)
Parameter
reg_list
reg_list is a list of type AQ$_REG_INFO_LIST that provides information about each subscription that you want to register. Each entry in the list is of the type AQ$_REG_INFO and can 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 to perform on notification. Currently, only calls to PL/SQL procedures are supported. The call taked the form:plsql://schema.procedure Where: schema specifies the schema in which the procedure resides. procedure specifies the name of the procedure to notify. |
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.UNREGISTER, disabling the notifications specified in the example for DBMS_AQ.REGISTER:
DECLARE
subscription1 sys.aq$_reg_info;
subscription2 sys.aq$_reg_info;
subscription3 sys.aq$_reg_info;
subscriptionlist sys.aq$_reg_info_list;
BEGIN
subscription1 := sys.aq$_reg_info('q', DBMS_AQ.NAMESPACE_AQ,
'plsql://assign_worker?PR=0',HEXTORAW('FFFF'));
subscription2 := sys.aq$_reg_info('q', DBMS_AQ.NAMESPACE_AQ,
'plsql://add_to_history?PR=1',HEXTORAW('FFFF'));
subscription3 := sys.aq$_reg_info('q', DBMS_AQ.NAMESPACE_AQ,
'plsql://reserve_parts?PR=2',HEXTORAW('FFFF'));
subscriptionlist := sys.aq$_reg_info_list(subscription1,
subscription2, subscription3);
dbms_aq.unregister(subscriptionlist, 3);
commit;
END;
/The subscriptionlist is of type sys.aq$_reg_info_list and contains sys.aq$_reg_info objects. The list name and an object count are passed to dbms_aq.unregister.