Kbase P94261: How error conditions are handled on errors occurred within a database trigger block
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2004 |
|
Status: Unverified
GOAL:
How error conditions are handled on errors occurred within a database trigger block
FIX:
When a error condition is raised within a database trigger block by a RETURN ERROR executed by that trigger there is a Default Processing that undoes and retry the nearest REPEAT, FOR EACH, or procedure block. To Override Default Processing use ON ERROR phrase.
eg: REPEAT ON ERROR UNDO, LEAVE:
It is important to understand that progress will not retry when an error occurs in a potentially iterative block with no code to control or customized error handling. Please see Solution P23658, An 'UNDO, RETRY' is changed during runtime to an 'UNDO, LEAVE'!