PL/SQL (MOSC)

MOSC Banner

^c out of pl/sql block

edited Oct 15, 2009 3:54AM in PL/SQL (MOSC) 13 commentsAnswered
 I do not use pl/sql frequently and need some help in understanding why the following would occur.

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

@scp_ip_root

@scp_ip_time_series

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center