This content has been marked as final. Show 2 replies
It is better to use WHENEVER SQLERROR EXIT if it is dangerous to proceed after errors happen. SQL*Plus will flush and close spool file.
Or you can close spool file. Then, after ACCEPT ... PROMPT ... you have to spool to another file, or you can override the existing one.
Thanks, I had thought about stopping and appending, but I'm going to look more into the whenever error command. I think that is a much better solution.