Packages in oracle database

[Garlands]

Sponsored Links

What is the use of packages in oracle database,another facility of database like functions and procedures are available. what is the purpose of creating packages and how it would be constructed. what is the difference between bodiless and normal packages.

[Praetor]

Packages:
A package is constructed using the collection of some procedures, functions, variables and SQL statements which is treated as a single unit.A package having two sections :

1. Package Specification
2. Package Body.

The first part of the package contains some declaration like variables ,types,exceptions,cursor ,etc and on other hand the second part of the package body contains some valuable code that builds a package.

[Katty]

Creating specification of Package:

A package specification act as an interface for package.It contains some declaration of variable and required specification for body construction.

The syntax would be as follows;

PACKAGE Package_name
 IS
[Declaration of variables and types] 
[specification of cursor]
[specification of modules]

END [Package_name];

[kelfro]

Creating package body:

Package body holds all the code and implement the subprograms, queries. It generate the some action with the help of specification packages and helps to retrieve the required information through the constructed package.

The syntax would be as follows :

PACKAGE BODY Package_name
 IS
 [Declaration of variables and types] 
    [specification and SELECT statement of cursor]
       [specification and body of modules]
           [BEGIN 
             executable statements ]

[EXCEPTION exception handlers]

         END [Package_name];