Finding View Errors

[CoffeeK1d]

I'm recreating a view from the dev environment into my schema. During that process, the view was created with errors, but the application didn't notify me.

Here are my questions:
1. How can I enable error messages like "ORA-24344: success with compilation error" to display when creating a view?

2. How can I see errors of the invalid objects in the object browser (details from ALL_ERRORS)?

 

[Marco Kalter]

Can you provide an example of a view that has an unreported compilation error? I cannot immediately reproduce this.

 

[CoffeeK1d]

-- ORA-01031: insufficient privileges
--    WITHOUT FORCE: IDE popped up with an error message box and statusbar message stating ORA-01031: insufficient privileges
--    WITH FORCE   : IDE accepted view with a statbar message of 'Done in n.nnn seconds'
CREATE OR REPLACE FORCE VIEW jgust.v_bad_view1 AS
SELECT *
FROM SCH_FRAME_RPT.T_ERROR_DTL;

The error looks to be caused by the keyword FORCE, which was added when I extracted the DDL.

Desired behavior if it is possible
1. At the time of creating the view, display multiple error messages
ORA-24344: success with compilation error
ORA-01031: insufficient privileges (error from ALL_ERRORS)
2. Have an errors folder in the object browser to identify the cause (error from ALL_ERRORS)

 

[Marco Kalter]

Thanks! At the moment you will indeed not get a warning or error message. We'll fix this.

The "Compile Invalid Objects" tool will include the invalid view, will display the errors, and will allow you to recompile it.

We'll enhance the SQL Window to show the error as well.