DROP_SUBSCRIPTION Procedure

This procedure drops a subscription that was created with a prior call to the GET_SUBSCRIPTION_HANDLE procedure.

Syntax

DBMS_LOGMNR_CDC_SUBSCRIBE.DROP_SUBSCRIPTION (
subscription_handle	IN NUMBER)

Parameters

Table 26-16 DROP_SUBSCRIPTION Procedure Parameters  

Parameter	Description
subscription_handle	Unique number of the subscription handle that was returned by a previous call to the GET_SUBSCRIPTION_HANDLE procedure.

Exceptions

Table 26-17 DROP_SUBSCRIPTION Procedure Exceptions  

Exception	Description
ORA-31425	Subscription handle does not exist or handle does not belong to this user. Call the function again with a valid subscription handle.
ORA-31430	The subscriber view was not dropped prior to making this call. Call the DROP_SUBSCRIBER_VIEW procedure and then try the original command again.

Usage Notes

• Prior to dropping a subscription, you must drop the subscriber view using the DBMS_LOGMNR_CDC_SUBSCRIBE.DROP_SUBSCRIBER_VIEW procedure.

Example

EXECUTE DBMS_LOGMNR_CDC_SUBSCRIBE.DROP_SUBSCRIPTION (\

SUBSCRIPTION_HANDLE => :subhandle);