Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOGMNR_CDC_SUBSCRIBE, 2 of 9
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.
DBMS_LOGMNR_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE( |
|
IN VARCHAR2, |
|
IN VARCHAR2 := NULL, |
|
OUT NUMBER) |
The
GET_SUBSCRIPTION_HANDLE
procedure allows a subscriber to register interest in a change set associated with source tables of interest.
EXECUTE sys.DBMS_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE(\CHANGE_SET=>'SYNC_SET', \ DESCRIPTION=>'Change data for emp',\ SUBSCRIPTION_HANDLE=>:subhandle);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|