Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_AQ, 11 of 24


AQ Registration Info Type

The aq$_reg_info data structure identifies a producer or a consumer of a message.

Syntax

TYPE sys.aq$_reg_info IS OBJECT (
   name      VARCHAR2(128),
   namespace NUMBER,
   callback  VARCHAR2(4000),
   context   RAW(2000));

Attributes

Table 4-8 AQ Registration Info Type Attributes
Attribute  Description 
name
 

Specifies the name of the subscription.

The subscription name is of the form <schema>.<queue> if the registration is for a single consumer queue and <schema>.<queue>:<consumer_name> if the registration is for a multiconsumer queues.  

namespace
 

Specifies the namespace of the subscription.

To receive notifications from AQ queues the namespace must be DBMS_AQ.NAMESPACE_AQ.

To receive notifications from other applications via DBMS_AQ.POST or OCISubscriptionPost(), the namespace must be DBMS_AQ.NAMESPACE_ANONYMOUS. 

callback
 

For HTTP notifications, the form is http://www.company.com:8080 

callback
 

Specifies the action to be performed on message notification.

For email notifications, the form is mailto://xyz@company.com

For AQ PL/SQL Callback, use plsql://<schema>.<procedure>?PR=0 for raw message payload OR

plsql://<schema>.<procedure>?PR=1 for ADT message payload converted to XML 

context
 

Specifies the context that is to be passed to the callback function. Default: NULL  

Table 4-9 shows the actions performed when different notification mechanisms/presentations are specified for nonpersistent queues.

Table 4-9 Nonpersistent Queues
Queue Payload Type   Presentation Specified 
RAW  XML 
Notification Mechanism  Notification Mechanism  
OCI  Email  PL/SQL Callback  OCI  Email  PL/SQL Callback 

RAW 

The callback receives the RAW data in the payload. 

Not supported 

The PL/SQL callback receives the RAW data in the payload. 

The callback receives the XML data in the payload. 

The XML data is formatted as an IDAP message and emailed to the registered email address. 

The PL/SQL callback receives the XML data in the payload. 

ADT 

Not supported. 

Not supported. 

Not supported. 

The callback receives the XML data in the payload. 

The XML data is formatted as an IDAP message and emailed to the registered email address. 

The PL/SQL callback receives the XML data in the payload. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback