Managing Packages

Previous

Next

You can create, modify, and drop packages and package bodies using the Object Browser page, the SQL Commands page, the Script Editor page, or SQL Command Line (SQL*Plus). You can view existing packages and package bodies with the Object Browser page.

The SQL CREATE PACKAGE statement is used to create package specification (specs). The CREATE PACKAGE BODY statement is used to define the package body.

This section contains the following topics:

• Writing Packages With PL/SQL Code

• Creating Packages in the SQL Commands Page

• Creating Packages With the Object Browser Page

• Viewing Packages With the Object Browser Page

• Creating Packages With the SQL CREATE PACKAGE Statement

• Editing Packages

• Dropping Packages

• Calling Procedures and Functions in Packages

• Accessing Variables in Packages