Package declaration and body : Package Body « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Package Body

SQL>
SQL>
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PACKAGE myPackage
  2  IS
  3     PROCEDURE calc_total (zone_in IN VARCHAR2);
  4
  5     PROCEDURE calc_total (reg_in IN VARCHAR2);
  6
  7  END myPackage;
  8  /

Package created.

SQL>
SQL>
SQL> CREATE OR REPLACE PACKAGE BODY myPackage
  2  IS
  3     PROCEDURE calc_total (zone_in IN VARCHAR2)
  4     IS
  5     BEGIN dbms_output.put_line ('zone'); END;
  6
  7     PROCEDURE calc_total (reg_in IN VARCHAR2)
  8     IS
  9     BEGIN dbms_output.put_line ('region'); END;
 10
 11  END myPackage;
 12  /

Package body created.

SQL>
SQL>
SQL>
SQL>