Overloading calls : Overloading « Function Procedure Packages « Oracle PL/SQL Tutorial






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

You can declare local or packaged stored procedures with exactly the same name, as long as their parameters are different by at least one of these factors:

  1. the number of parameters,
  2. names of parameters,
  3. order of parameters, or
  4. the datatype family of the parameters.








27.19.Overloading
27.19.1.Overloading calls
27.19.2.Number of parameters
27.19.3.Names of parameters
27.19.4.Datatype family of parameters
27.19.5.There are some restrictions on overloading:
27.19.6.More than one match was found so Oracle raised a special error.