Oracle Objects for OLE
Release 9.2

Part Number A95895-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Add (OraSubscriptions Collection)

See Also
Example


Applies To

OraSubscriptions Collection

Description

Adds a subscription to the OraSubscriptions collection.

Usage

orasubscriptions.Add Name, DbeventsHdl, Ctx

Arguments
Description
[in]Name
The Dbevent of interest. The appropriate event trigger and AQ queue must be set up prior to this.

Name here refers to the subscription name in the form of the string 'SCHEMA.QUEUE' if the registration is for a single consumer queue and 'SCHEMA.QUEUE:CONSUMER_NAME' if the registration is for a multi-consumer queue.

The Name string should be in uppercase.

[in] DbeventsHdl
The database event handler. An IDispatch interface implementing the NotifyDBEvents method which is invoked when the database event of interest is fired.

[in] Ctx
Context-specific information that the application wants passed to NotifyDbEvents when it is invoked.

Remarks

To register for subscription of a dbevent, the name identifying the subscription of interest and the dbevent handler that handles the event must be passed in when the Add method is called. The queues and event triggers necessary for supporting the database event must be set up before the subscriptions can be fired.

The dbevent handler should be an automation object that implements the method NotifyDBEvents. The NotifyDBEvents method is invoked by Oracle Objects for OLE when database events of interest are fired.

For more detailed information about setting up the queues and triggers for Oracle Database Events, refer to the Oracle9i Database Concepts, section on Triggers on System Events and User Events.

The syntax of the method is:

Public Function NotifyDBEvents(ByVal Ctx As Variant, ByVal Payload As

Variant

Variant
Description
[in] Ctx
Passed into OraSubscriptions.Add method by the application. Context-sensitive information that the application wants passed on to the dbevent handler.

[in] Payload
The payload for this notification. Dbevents are fired by setting up event trigger and queues. Payload here refers to the payload, if any that was enqueued in the queue when the event triggered.

 
Oracle
Copyright © 1994, 2002 Oracle Corporation.

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

Master Index

Feedback