16.20 - SPL1117: "%s: Undo declare handler not allowed in NON ATOMIC BLOCK." - Teradata Vantage NewSQL Engine

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

SPL1117: "%s: Undo declare handler not allowed in NON ATOMIC BLOCK."

Explanation:

UNDO declare handler is given in a non-atomic block.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Look whether the block is NON Atomic , then change the declare handler to what is valid in NON Atomic.