Data Merger Precommit Stored Procedure Call

The Data Merger can be configured to call a stored procedure after a database insert, update, or delete operation and before a transaction commit. You can use this stored procedure to accomplish further processing inside the database and have the results returned to the plug-in. You can specify this precommit stored procedure name in the Stored Procedure field on the Data Merger activity's Advanced tab.

The precommit stored procedure is called with the following syntax:

{call <precommit stored procedure name>(?, ?, ?,)}.

This stored procedure has to be defined with the following parameters:
Name Type Description
RETURN_CODE Integer RETURN_CODE=0.

The plug-in assumes the procedure was successful and writes a success message to the SDK INFO trace role when the verbose mode is used.

RETURN_CODE<>0

The plug-in assumes the procedure was not successful and writes SP_TEXT to the SDK ERROR trace role (whether or not the verbose mode is on or off).

If the message has a reply subject, this output value is returned to the message sender.

SP_TEXT Varchar If the message has a reply subject, this output string is returned to the message sender.
DO_ROLLBACK Integer DO_ROLLBACK=0.

The plug-in commits the transaction and confirms the original message.

DO_ROLLBACK<>0

The plug-in rolls back the transaction and does not confirm the message. Not confirming the message changes the RVCM behavior, and none of the subsequent RVCM messages are confirmed. It can be done only when this RVCM behavior is really desired.

Note: The Subscription Service processes only two records even though two or more records are sent to it. This happens if the Subscription Service is configured with the RVCMQ transport and calls a precommit stored procedure with the DO_ROLLBACK having value 1.