Catch simply compilation failure warnings
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.
0