|
Works with the replication_error option to allow you to specify a LONG VARCHAR stored procedure to be called by the Message Agent when a SQL error occurs during SQL Remote replication.
Stored procedure name
Empty string
| 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 |
If an error occurs and replication_error is defined, then the replication_error procedure is called with the full error string.
If replication_error and replication_error_piece are both defined, then the error is broken up into VARCHAR pieces. replication_error is called with the first piece and replication_error_piece is called repeatedly with the remaining pieces.