Wednesday 18 January 2012

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

Cause: The USERENV( COMMITSCN ) function can only be used once in a transaction.

Action: Re-write the transactioin to use USERENV( COMMITSCN ) only once

No comments:

Post a Comment