GET_SUBSCRIPTION_HANDLE Procedure

This procedure creates a subscription handle that associates the subscription with one change set. Creating a subscription handle is the first step in obtaining a subscription.

Syntax

DBMS_LOGMNR_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE(
change_set	IN VARCHAR2,
description	IN VARCHAR2 := NULL,
subscription_handle	OUT NUMBER)

Parameters

Table 26-2 GET_SUBSCRIPTION_HANDLE Procedure Parameters  

Parameter	Description
change_set	Name of an existing change set to which the application subscribes. You must set the value to SYNC_SET.
description	Describes the subscription handle and the purpose for which it is used.
subscription_handle	Unique number of the subscription handle for this subscription.

Exception

Table 26-3 GET_SUBSCRIPTION_HANDLE Procedure Exceptions  

Exception	Description
ORA-31415	Could not find an existing change set with this name.
ORA-31457	The maximum number of characters permitted in the description field was exceeded.
ORA-31458	This is an internal error. Contact Oracle Support Services and report the error.

Usage Notes

• The GET_SUBSCRIPTION_HANDLE procedure allows a subscriber to register interest in a change set associated with source tables of interest.

• To see all of the published source tables for which the subscriber has privileges, query the ALL_PUBLICATIONS view.

• A subscriber can later use a single subscription handle to access the multiple change tables in the subscription.

• Subscription handles:
  • Never get reused and are tracked from the time of creation until they are dropped with the DROP_SUBSCRIPTION procedure.

  • Are not shared among subscribers; rather, each subscription handle is validated against the subscriber's login ID.

Example

EXECUTE sys.DBMS_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE(\

CHANGE_SET=>'SYNC_SET', \
DESCRIPTION=>'Change data for emp',\
SUBSCRIPTION_HANDLE=>:subhandle);