Creating a package specification
Creating a package specification in PL/SQL defines the interface to the package and which functionalities are provided by the packages. The specification of the package works as the connection between the package and its users and defines the procedure, function, types, variables, and exceptions that are accessible in public.
PL/SQL Package Specification
PL/SQL ( Procedural Language/Structural Query Language ) is the extension of SQL ( Structured Query Language ) which is allowed to the developers for creating the procedural logic along with the Oracle database. The package is one of the main key componentss of PL/SQL development.
The PL/SQL package is the group of the related procedures, functions, variables, and other bundled constructs for providing the modularity and organized approach to application development. In PL/SQL, the package specification gives the blueprint of the functionalities that are provided by the PL/SQL package.
It is defined by the interface along with the PL/SQL code which interacts with the package. It works like an API ( Application Program Interface ) that defines how the external programs can interact with the software library.
Contact Us