Database Guide › Infrastructure-Based Purging › Purges and Stored Procedures › Public SPs

Public SPs

The public SPs provided by CA DLP include Stub SPs and Default SPs. The Stub SP is invoked directly by the CA DLP infrastructure. First, it checks for a ‘well known’ Custom SP, which it invokes if one exists. If no Custom SP is defined, the Stub SP invokes the Default SP.

The public SPs are summarized below. Each can be customized, but the SP for manual event purges does check for pre-purge or post-purge SPs. Note the SP naming requirements.

PUB_WGN_PURGE_STUB_1

Performs policy-determined purges.

Customizable.

Pre-purge and post-purge SPs supported.

PUB_WGN_MAN_PURGE_STUB_1

Performs policy-determined purges.

Customizable.

Pre-purge and post-purge SPs are not supported.

For details about each public SP (for example, parameter listings), please refer to comments within the SP itself.

Oracle Puiblic SPs

For Oracle databases, the public Stub and Default SPs are implemented as a single ‘package’. The package names are:

PUB_WGN_PURGE

Package for policy-determined purges

PUB_WGN_MAN_PURGE

Package for manually-specified purges

More information:

SP Names