Топ-100
 
CerebroSQL

Compilation of objects (Oracle DBMS)

The compiler allows you to correct errors, fix errors in the code, as well as view the list of errors for all objects.

Compiler window structure

CerebroSQL - Oracle compile invalid obje
Tree invalid object

A tree of objects in the Invalid status. 

  • Root Nodes - schema name

-> Request to retrieve data <-

select owner "Owner",
       count(*) "Count"
  from ALL_OBJECTS where status = 'INVALID'
group by owner order by 1

-----

  • First level child nodes - object types

-> Request to retrieve data <-

select object_type "Type",
       count(*) "Count"
  from ALL_OBJECTS
where status = 'INVALID'
  and owner = '$$SCHEMA_NAME'
group by object_type
order by 1

-----

  • Child nodes of the second level - objects in the ' Invalid ' status

-> Request to retrieve data <-

select object_name "Name"
  from ALL_OBJECTS
where status = 'INVALID'
  and object_type = '$$OBJECT_TYPE'
  and owner = '$$SCHEMA_NAME'
group by object_name
order by 1 

-----

Object code editor
  • In the tree "Tree invalid object" select the object

  • Press the button "Show code selected object"

    IMPORTANT: the create or replace construction must be absent in the text in the "Code invalid object" field.

List "Error list" - contains one line for each error in the object text. When you click, the cursor moves to the line with an error in the "Code invalid object" field

List all errors tab

Serves for viewing information on errors in database objects. The list can be sorted by schema, object type  

Compiling objects
  • In the tree "Tree invalid object" select the required level (schema, object type, object)

  • Press the "Run compile" button

The compilation process is monitored in the "Program Monitor"

Oracle compile invalid object.jpg