Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOGMNR_CDC_SUBSCRIBE, 3 of 9
This procedure specifies the source tables and source columns for which the subscriber wants to access change data.
There are two versions of syntax for the SUBSCRIBE
procedure, each of which specifies the subscriber columns and datatypes. If the subscribers know which publication contains the source columns of interest, the subscribers can use the version of the procedure that contains the publication ID. If they do not know the publication ID, the Change Data Capture system will select a publication based on the supplied source schema and source table.
The following syntax identifies the source table of interest, allowing Change Data Capture to select any publication that contains all source columns of interest.
DBMS_LOGMNR_CDC_SUBSCRIBE.SUBSCRIBE ( |
|
IN NUMBER, |
|
IN VARCHAR2, |
|
IN VARCHAR2, |
|
IN VARCHAR2) |
The following syntax specifies the publication ID for a specific publication that contains the source columns of interest.
DBMS_LOGMNR_CDC_SUBSCRIBE.SUBSCRIBE ( |
|
IN NUMBER, |
|
IN NUMBER, |
|
IN VARCHAR2) |
ALL_PUBLISHED_COLUMNS
view.
SUBSCRIBE
procedure allows an application to subscribe to one or more published source tables and to specific columns in each source table.
EXECUTE sys.DBMS_CDC_SUBSCRIBE.SUBSCRIBE(\SUBSCRIPTION_HANDLE=>:subhandle, \ SOURCE_SCHEMA=>'scott', \ SOURCE_TABLE=>'emp', \ COLUMN_LIST=>'empno, ename, hiredate');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|