Can I have procedures with the same name and number of parameters in the same package (ORACLE)?

0

Can I have a package with two procedures of the same name, number and type of parameters just diversifying the name of the parameters?

    
asked by anonymous 26.10.2015 / 20:21

1 answer

1

Yes, you can create one or more procedures, functions, etc ... in the same scope (eg package) with different or equal amounts of parameters, names and types.

The compiler will call the subroutine in which the passed parameters are identified, either in quantity or value type, if the type of a parameter does not match the statement an error will be returned.

Read about this in the oracle documentation:

Overloading Packaged Subprograms

Overloading Subprogram Names

    
03.11.2015 / 19:28