#rodsays #plsql
Add this:

WHENEVER SQLERROR EXIT


This means that if your table check generates an ORA-20001 error (or any other sql errors), nothing else will get run. Just in case someone runs the entire script. Without this, it would keep running everything after the error.
 
 
Back to Top