Compiler Window Structure
The compiler allows you to fix errors, fix errors in the code, and also view the list of errors for all objects.
Object tree (queries)
Tree of objects in Invalid status .
Root nodes - schema name
select owner "Owner",
from ALL_OBJECTS where status='INVALID'
group by owner order by 1
Child nodes of the first level - types of objects
select object_type "Type",
group by object_type
order by 1
Child nodes of the second level - objects in the status ' Invalid '
select object_name "Name"
and owner = '$$SCHEMA_NAME'
group by object_name
order by 1
Object code editor
In the tree " Tree invalid object " select an object
Press the button " Show code selected object "
IMPORTANT: the create or replace construct must be absent from the text in the "Code invalid object" field
List " Error list " - contains one line for each error in the text of the object. When clicked, the cursor is moved to the line with an error in the field " Code invalid object "
"List all errors" tab
Used to view information on errors in database objects. The list can be sorted by scheme, object type
In the " Tree invalid object " tree, select the desired level (scheme, object type, object)
Press the " Run compile " button
The compilation process is monitored in the " Program Monitor "