Compiling PL/SQL Programs

To compile a PL/SQL program:

Select View | Connection Navigator .
Expand Database.
Select a database connection and expand it.
Select a schema and expand it.
Select Packages and expand it.
Select a folder.
Right-click the program, and choose Make from the context menu. This saves and compiles the code by sending the source to the database as a CREATE OR REPLACE FUNCTION statement.

Invoking Make causes the program to be modified in the database, regardless of the success of the compilation. Any previous definition of the program will be lost. (In the case of PL/SQL programs, Make, Rebuild, and Save have the same effect.)

Note: Package bodies are contained within their Package folders.