Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to display compiler error messages in SQL Developer

525140Sep 9 2008 — edited Sep 10 2008
This 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2008
Added on Sep 9 2008
2 comments
1,142 views