2017-12-21 21:50 GMT+01:00 Rakesh Kumar <rakeshkumar...@mail.com>: > whenever SQLERROR EXIT ROLLBACK >
Thanks. You are absolutely right. After starting with: WHENEVER SQLERROR EXIT ROLLBACK the process getting the deadlock will exit to command prompt (with %ERRORLEVEL% = 0). So what actually found out was that Oracle has some strange combinations of default values regarding 1. AUTOCOMMIT = 0 2. Don't exit/rollback on deadlock
