PL/SQL cryptic warning: “Procedure created with compilation errors.”
2011 April 24
Many times PL/SQL won’t tell you what is wrong with your procedure and it will just print this cryptic message:
Warning: Procedure created with compilation errors.If you don’t see any error in your code, use the following command:
SHOW ERRORS PROCEDURE <procedure_name>;It will output something like which makes it much easier to debug the procedure:
SQL> SHOW ERRORS PROCEDURE add_book
Errors for PROCEDURE ADD_BOOK:
LINE/COL ERROR
-------- -----------------------------------------------------------------
28/3 PL/SQL: SQL Statement ignored
29/20 PL/SQL: ORA-00984: column not allowed hereYou can use similar command not only with procedures:
SHOW ERRORS FUNCTION
SHOW ERRORS PACKAGE
SHOW ERRORS PACKAGE BODY
SHOW ERRORS TRIGGER
SHOW ERRORS VIEW
etc
One Response
leave one →
Thanks!