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!

Compiling a view doesn't show errors

633583Jul 1 2008 — edited Jul 3 2008
Hello,

Compiling a PL/SQL procedure shows compilation errors correctly, but compiling a view says "view compiled" without reporting the errors. It seems the only way to see the errors is to do select * from user_errors afterwards. Or is there a setting somewhere?

It's also slightly odd that it asks for confirmation before compiling the view, whereas PL/SQL compilation does it right away. I'd prefer the latter.

I'm using version 1.5.1 on Linux (Ubuntu).

Many thanks

Ed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2008
Added on Jul 1 2008
3 comments
1,700 views