What are two parts of package ?

The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

Interview Candidate
Sep 9th, 2004
2
4620

PL/SQL

Answer

Showing Answers 1 - 2 of 2 Answers

Mahesh Argade

Jun 28th, 2006

In addition to this
Both Package Spec and Package Body are stored separately in the Data base
Package specifications act as an interface for the Package

g_sidhu
Profile

Jan 31st, 2008

A package usually has a specification and a body, stored separately in the database.
The specification is the interface to your applications. It declares the types, variables, constants, exceptions, cursors, and subprograms available for use. The package specification may also include PRAGMAs, which are directives to the compiler.
The body fully defines cursors and subprograms, and so implements the specification.