EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Working with recompile service


Schema

Use the drop-down list to select the schema containing objects to search.

 

Object type

Use the drop-down list to select the object type to search.

 

CheckBox With debug info

Adds the code for PL/SQL debugger.

 

To perform the search, click the iconFindText Find invalid objects link on the Navigation bar.

To get dependencies of invalid objects click the iconGetInvalidDependencies Get invalid dependencies link on the Navigation bar.

 

Recompile Invalid Objects - Working with recompile service

 

The list below displays invalid objects of the specified type found within the selected schema as a grid with the following columns: Object name, Object ID, Hint. If more convenient, you can change the order of the columns by dragging their headers horizontally.

 

Hint: Objects of different type are marked in the list by different icons.

 

To recompile invalid objects, click the iconCompileWithDebugInfo Recompile all invalid objects link on the Navigation bar.

 

If you want to recompile a single dependency that is currently selected the click the iconRecompileDependency Recompile dependency link on the Navigation bar.

If you want all dependencies to be recompiled then click the Recompile all dependencies link on the Navigation bar.