What is the difference between private packages and public package . what is the difference in declaration of these 2 packages.

Interview Candidate
Apr 18th, 2007
6
9500

Showing Answers 1 - 6 of 6 Answers

KiranKW
Profile Answers by KiranKW

May 2nd, 2007

hi ,

i dont think there is something called as public package / private package. But yes the methods defined in a package can either be public or private.

Below is a simple expln.

Variables and constants that are not defined within any function or procedure in the package are called package data.
Package data declared inside the package specification is called public package data.
Package data declared inside the package body is called private package data.
Private package data can be accessed only by elements defined in the package itself.
Public package data can be accessed by the package itself and by any program that can execute that package.
Package data structures, public and private, act like globals and persist within a single Oracle session or connection.