Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOGMNR_CDC_SUBSCRIBE, 6 of 9
This procedure creates a subscriber view in the subscriber's schema in which the subscriber can query the change data encompassed by the current subscription window.
DBMS_LOGMNR_CDC_SUBSCRIBE.PREPARE_SUBSCRIBER_VIEW ( |
|
IN NUMBER, |
|
IN VARCHAR2, |
|
IN VARCHAR2, |
|
OUT VARCHAR2) |
EXTEND_WINDOW
procedure) for the subscription window.
SELECT
statement from these views and retrieve the change data. For the purpose of the following example, assume that sys.sub9view
was the view name returned by the PREPARE_SUBSCRIBER_VIEW
procedure:
SELECT * FROM sys.sub9view; . . .
view_name
(for example, if the previous view was not dropped with a DROP VIEW
DDL statement), an exception occurs. The PREPARE_SUBSCRIBER_VIEW
procedure checks if the underlying change table still exists.
EXECUTE sys.DBMS_CDC_SUBSCRIBE.PREPARE_SUBSCRIBER_VIEW( \SUBSCRIPTION_HANDLE =>:subhandle, \ SOURCE_SCHEMA =>'scott', \ SOURCE_TABLE => 'emp', \ VIEW_NAME => :viewname);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|