Packages and Programs Compilation

If a package, an object or a stored procedure is invalid you have to compile one to make it work.

The whole package is considered invalid if its specification contains errors. An object status is also determined by the validity of its specification. Project body or object body becomes invalid if at least one procedure or function that makes up the body is invalid. Stored procedure or function is invalid when its code contains errors.

PL/SQL programs can be compiled by right-clicking the node in the Database Explorer window, and choosing corresponding command from the Compile submenu of the shortcut menu. You can compile PL/SQL programs with or without debug information.

Compilation Warnings

When working with Oracle server 10.1 or higher, you can enable compilation warnings. By default compilation warnings are ignored. To enable them, perform the following steps:

  1. In the Database Explorer window, right-click a connection, and then click Modify Connection on the shortcut menu.
  2. Go to the Advanced tab.
  3. Select the Show PL/SQL compilation warnings check box.
  4. Click OK.

After performing these steps you can work with PL/SQL compilation warnings in the same way as with compilation errors.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?