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 :
Code:
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];
Bookmarks