Oracle Programming language PL / SQL

Asked By swabi 0 points N/A Posted on - 08/05/2011

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

• Status: Open
• Question Views: 909
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Caitlyn 0 points N/A #99890

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.

About Caitlyn

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/05/2011
• Question Category: Oracle Database