Defining a stored procedure user exit

There are a number of factors you should consider before defining a stored procedure user exit.

When defining a stored procedure user exit in CDC Replication, consider the following:

• Overloaded stored procedures are not supported.
• Stored procedure user exits must have at least two parameters, which must be the first two defined in the following order:

  result

  An integer output parameter that returns '0' if the stored procedure user exit is successful or a non-zero value if the stored procedure user exit is not successful.

  returnMsg

  A character output parameter that returns error messages to the Event Log if the stored procedure user exit is not successful.