12-13. Compiling Code Within the Navigator

Problem

You want to compile some PL/SQL code within Oracle SQL Developer. In this solution, the navigation menu of your Oracle SQL Developer environment contains code that has a red X on it. This means the code needs to be compiled or that it contains an error.

Solution

Select the code that needs to be compiled, and right-click (Ctrl+click) it. A menu will be displayed that lists several options. Select the Compile option from that menu (Figure 12-45).

Image

Figure 12-45. Compile option

How It Works

The Oracle SQL Developer navigation menu is very handy for quickly glancing at the code that a database contains. ...

Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.