-881   A SAVEPOINT WITH NAME savepoint-name ALREADY EXISTS, BUT THIS SAVEPOINT NAME CANNOT BE REUSED

Explanation

The SAVEPOINT statement uses the same savepoint name as another savepoint, and it cannot be created because at least one of the savepoints was defined with the UNIQUE clause to indicate that the name cannot be reused within the transaction.

System action

The statement is not executed and a new savepoint is not set. The old savepoint still exists.

Programmer response

Correct the statement. Either use a different savepoint name, or omit the UNIQUE clause if the other savepoint was created without the UNIQUE clause and your intention is to reuse that savepoint name.

SQLSTATE

3B501