Show stored procedures or triggers errors when compiling on Oracle

Stored procedures

sqlplus admin/password@SID
alter procedure PROCEDURE_NAME compile;
show errors;

Triggers

sqlplus admin/password@SID
alter trigger TRIGGER_NAME compile;
show errors;

Loading