Home > Oracle, SQLPlus, Utilities > Oracle: SQL*Plus displays “No errors.”

Oracle: SQL*Plus displays “No errors.”

Problem description:

Your are compiling an object, but it fails with an error. If you are trying to check the error message(s) for the compilation, SQL*Plus displays “No errors.”:

SQL> ALTER VIEW VIEWNAME compile;
 
Warning: VIEW altered WITH compilation errors.
 
SQL> SHOW errors
No errors.
SQL>

 
Problem resolution:

“show errors” only displays the last error message generated. In some cases (like above) no error messsage will be displayed. In order to force the display of error messages for a specific object, make use of the full functionality of “show errors” and specify the type and name of your object:

SQL> SHOW errors VIEW VIEWNAME
Errors FOR VIEW VIEWNAME:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-01730: invalid NUMBER OF COLUMN names specified
SQL>

 
You can also use this method to display errors for other objects and object types:

SHOW ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER |
                VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
Categories: Oracle, SQLPlus, Utilities Tags:
  1. No comments yet.
  1. No trackbacks yet.

Connect with Facebook