Compiling a view doesn't show errors
633583Jul 1 2008 — edited Jul 3 2008Hello,
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