More OCI Relational Functions, 51 of 106

OCISubscriptionUnRegister()

Purpose

Unregisters a subscription which turns off notifications.

Syntax

ub4 OCISubscriptionUnRegister ( OCISvcCtx         *svchp,
                                OCISubscription   *subscrhp,
                                OCIError          *errhp
                                ub4               mode );

Parameters

svchp (IN)

An OCI service context (after release 7). This service context should have a valid authenticated user handle.

subscrhp (IN)

A subscription handle with the OCI_ATTR_SUBSCR_NAME and OCI_ATTR_SUBSCR_NAMESPACE attributes set.

See Also:

For information, see Subscription Handle Attributes

errhp (OUT)

An error handle you can pass to OCIErrorGet() for diagnostic information in the event of an error.

mode (IN)

Call-specific mode. Valid value:

OCI_DEFAULT - executes the default call

Comments

Unregistering to a subscription is going to ensure that the user will not receive notifications regarding the specified subscription in future. If the user wishes to resume notification, then the only option is to re-register to the subscription.

All notifications that would otherwise have been delivered are not delivered after a subsequent register is performed because the user is no longer in the list of interested clients.

Related Functions

OCIAQListen(), OCISvcCtxToLda(), OCISubscriptionEnable(), OCISubscriptionPost(), OCISubscriptionRegister().

Direct Path Loading Functions

This section describes the direct path loading functions.

Table 16-4 Direct Path Loading Functions

Function	Purpose
`OCIDirPathAbort()`	Aborts a direct path operation
`OCIDirPathColArrayEntryGet()`	Gets a specified entry in a column array
`OCIDirPathColArrayEntrySet()`	Sets a specified entry in a column array to a specific value
`OCIDirPathColArrayRowGet()`	Gets the base row pointers for a specified row number
`OCIDirPathColArrayReset()`	Resets the row array state
`OCIDirPathColArrayToStream()`	Converts from a column array to a direct path stream format
`OCIDirPathDataSave()`	Does a data savepoint, or commits the loaded data and finishes the load operation
`OCIDirPathFinish()`	Finishes and commits the loaded data
`OCIDirPathFlushRow()`	Loads data that has been converted to direct path stream format
`OCIDirPathLoadStream()`	Loads the data converted to direct path stream format
`OCIDirPathPrepare()`	Prepares direct path interface to convert or load rows
`OCIDirPathStreamReset()`	Resets the direct path stream state