Oracle Programming language PL / SQL

Asked By 0 points N/A Posted on -
qa-featured

You have just compiled a PL/SQL package but got errors, how would you view the errors?

SHARE
Answered By 0 points N/A #99890

Oracle Programming language PL / SQL

qa-featured

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.

Login/Register to Answer

Related Questions