Allows you to specify a stored procedure to be called by the Message Agent when a SQL error occurs.
Stored procedure name
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY USER DEFINED OPTION||Yes||Yes, with SET ANY USER DEFINED OPTION|
|Allowed to set temporarily?||No||No||No|
For SQL Remote, the replication_error option allows you to specify a stored procedure to be called by the Message Agent when a SQL error occurs. By default, no procedure is called.
The procedure must have a single argument of type CHAR, VARCHAR, or LONG VARCHAR. The procedure is called once with the SQL error message and once with the SQL statement that causes the error. In some circumstances (such as foreign key violations), the SQL statement that caused the error is not available, so the stored procedure can only be called once.
Although the option allows you to track and monitor SQL errors in replication, you must still design them out of your setup; this option is not intended to resolve such errors.