Oracle Programming language PL / SQL
By default, PL/SQL compilation errors are not reported. It will just give you a message saying “warning: procedure created with compilation errors”. So if you want the error(s) to be listed, you can try issuing the command:
SQL> SHOW ERRORS
Alternatively, you can use the PLVvu package, there is a built in err procedure there. The procedure’s header goes like this:
PROCEDURE err (name_in IN VARCHAR2 := NULL, overlap_in IN INTEGER := overlap);
name_in is the name of the program unit, overlap_in is the numbers of lines of code to display. If the name is not defined, the most recently compiled program unit errors will be shown.