Friday, 25 May 2012

Is it possible to write a package specification without a package body? | PL SQL

Yes, it is possible to write a package specification without a package body but not the vice versa. This is specifically used if there is a package, which is only used for the declaration of public variables, types, constants, and exceptions. In such case, there is no need for a package body and only package specification is enough.