Previous Topic: Customizable Stored Procedures and FunctionsNext Topic: SET_METRICS_STUB_1


General

To customize a stored procedure, a new stored procedure needs to be created, that has the same interface as the distributed stored procedure, but with a name that replaces the characters STUB_x. For:

SQL Server

The suffix STUB_x must be replaced with CUSTOM_x, where 'x' is the version number.

Oracle

The STUB_x suffix must be removed.

For example in SQL Server, to customize the stored procedure WGN_RQ_SET_METRICS_STUB_1, a new stored procedure must be created called WGN_RQ_SET_METRICS_CUSTOM_1 that has the same interface defined as WGN_RQ_SET_METRICS_STUB_1.

The above applies to functions as well as to stored procedures.