SET ERRORLOGGING ON doesn't work with WHENEVER SQLERROR EXIT FAILURE ROLLBACK
Hello,a developer of one of our departments wants to track erros occuring during a simple Sql Plus script runs in the errorlog table with the common instruction "SET ERRORLOGGING ON".
So far okay.
In addition an error is raised he wants to exit the script AND rollback all the uncommited statements until the error is generated using the "WHENEVER SQLERROR EXIT FAILURE ROLLBACK" instruction.
However when the script runs into an error the exit and rollback works fine and unfortuately also the rollback on the errorlog table. It seems this is behaviour is "works as desigend".
Is there a (simple) workaround for tracking the error in the errorlog and just rollback the other statements in a sql plus script?
So far okay.
In addition an error is raised he wants to exit the script AND rollback all the uncommited statements until the error is generated using the "WHENEVER SQLERROR EXIT FAILURE ROLLBACK" instruction.
However when the script runs into an error the exit and rollback works fine and unfortuately also the rollback on the errorlog table. It seems this is behaviour is "works as desigend".
Is there a (simple) workaround for tracking the error in the errorlog and just rollback the other statements in a sql plus script?
0