SQL*Plus (MOSC)

MOSC Banner

Catch simply compilation failure warnings

edited Oct 15, 2013 9:28PM in SQL*Plus (MOSC) 8 commentsAnswered
 Hi,A colleague has asked me if it was possible to catch simply compilation errors within SQL*Plus, but I couldn't think of any easy way.
I browsed the SQL*Plus User's guide and reference but I couldn't find anything on that subject.
So maybe some of you know of some ways or tricks to do so.

For example, say I have a script that creates 2 procedures p1 and p2 one after the other:

create or replace procedure p1
is
...
end;
/
create or replace procedure p2
is
...
end;
/     

If p1 doesn't compile successfully, I don't want to compile p2.
The problem is that SQL*Plus will inform me that p1 was created with compilation errors, but I can't seem to monitor that warning.

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