SQLPlus ERRORLOGGING issues with error log on rollback resolved Today I came up with idea to overcome the issue:Â SQLPlus ERRORLOGGING does not keep error log on rollback. The resolution is to use autonomous transactions to log the errors reported by SQL Plus. What we need to do is to somehow catch the error that is about to be logged and wrap it in an… Read More
SQLPlus ERRORLOGGING does not keep error log on rollback Recently I’m heavily involved in SQL*Plus scripting automation tasks. I must admit that despite all the settings you may set and retrieve with SQL*Plus, it is a real pain to do some good automation with this tool. I’m very glad that Oralce continues to extend Oracle SQL*Plus features, but i must say that it seems… Read More