Stored Procedure Accelerator Guide for Oracle

9.9.2
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Overloaded Program Units

You can use overloaded program units that have different numbers of arguments, but you cannot use not overloaded program units that have the same number of arguments with different argument types.

For example, you can use the following package that contains overloaded functions with the same name and a different number of arguments:

CREATE OR REPLACE  PACKAGE SP_FUN_PACKAGE IS
/* Number of arguments : 5 */
FUNCTION fun_with_in_args_pkg_table(
in_int number,
in_var varchar2,
in_date date,
v_ref out SYS_REFCURSOR,
v_ref2 out SYS_REFCURSOR)
RETURN pkg_table_type PIPELINED;

/* Number of arguments : 4 */
FUNCTION fun_with_in_args_pkg_table(
in_int number,
in_int1 number,
in_var varchar2,
in_date date,
v_ref out SYS_REFCURSOR)
RETURN pkg_table_type PIPELINED;
END;

However, you cannot use the following package, which contains overloaded functions with the same name and same number of arguments:

CREATE OR REPLACE  PACKAGE SP_FUN_PACKAGE IS

/* Number of arguments : 4 */
FUNCTION fun_with_in_args_pkg_table(
in_int number,
in_var varchar2,
in_date date,
v_ref out SYS_REFCURSOR)
RETURN pkg_table_type PIPELINED;

/* Number of arguments : 4 */
FUNCTION fun_with_in_args_pkg_table(
in_int number,
in_int1 number,
in_var varchar2,
v_ref out SYS_REFCURSOR)
RETURN pkg_table_type PIPELINED;
END;

Rename Saved Search

Table of Contents

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

Overloaded Program Units

Overloaded Program Units