^c out of pl/sql block
Why I had to ^C out of a pl/sql block to continue with my script in one case and not in another.
Both blocks are run in sql scripts within the same session.
connect / as sysdba
exit
The blocks are within the above 2 scripts and are structured exactly the same but work on different tables.
The block within the first script exits normally to the rest of the script with no intervention.
-- Copy the data from the renamed table