Oracle Solution for Error ora-01721
ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction
What triggered the Error:
The USERENV('COMMITSCN') function can only be used once in a transaction.What should we do to fix it:
Re-write the transactioin to use USERENV('COMMITSCN') only once
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
