sqlplus.exe - how to know if an error occured during file execution script
I have a program that run automatically some script files using sqlplus.exe. For some reasons the customer want to run all statements from the files even if errors are encountered.
For each script file I need to store if execution was done without errors.
I know that the use of WHENEVER SQLERROR EXIT FAILURE would help me but will also stop executing the rest of statements from files so is not a solution.
I can only insert some commands at the beggining or to the end of the scripts. Any ideas?
Thanks a lot!