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> 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>