how to display compiler error messages in SQL Developer
525140Sep 9 2008 — edited Sep 10 2008This was originally posted on the SQL and PL/SQL forum.
I have a file x.sql which contains a PL/SQL package and package body. When I open the file in SQL Developer and run it, I might get messages in the log window like:
package xops_common_api Compiled.
Warning: execution completed with warning
package body xops_common_api Compiled.
If I subsequently right click on the package body in the navigator and choose "Compile", then the body will be compiled and explicit error messages appear in the log window, showing syntax errors and line numbers.
How can I get the compiler error messages to appear the first time, without having to recompile from the navigator?