Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Function Procedure Packages

 

Creating a Package Body

You create a package body using the CREATE PACKAGE BODY statement. The simplified syntax for the CREATE PACKAGE BODY statement is as follows: SQL> SQL> CREATE [OR REPLACE] PACKAGE BODY package_name   2  {IS | AS}   3    package_body   4  END package_name; where package_name specifies the name of the package, which must match the package name previously set in the package specification. package_body specifies the code for the procedures and functions, along with any variables and cursors.