oracle 函数 实现重载_Oracle文档关于模块重载的一个例子，其实是可以。

文档版本：

Oracle® Database PL/SQL User's Guide and Reference

10g Release 2 (10.2)

Part Number B14261-01

文档范例如下：

Example 8-9 Restrictions on Overloading PL/SQL Procedures

DECLARE

PROCEDURE balance (acct_no IN INTEGER) IS

BEGIN NULL; END;

PROCEDURE balance (acct_no OUT INTEGER) IS

BEGIN NULL; END;

BEGIN

DBMS_OUTPUT.PUT_LINE('The following procedure call raises an error.');

-- balance(100); raises an error because the procedure declaration is not unique

END;

/

其实我在测试的时候，发现是可以的。 如下：

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Connected as xxxx

SQL>

SQL> set serveroutput on

SQL>

SQL> DECLARE

2     PROCEDURE balance (acct_no IN INTEGER) IS

3     BEGIN NULL; END;

4     PROCEDURE balance (acct_no OUT INTEGER) IS

5     BEGIN NULL; END;

6  BEGIN

7    DBMS_OUTPUT.PUT_LINE('The following procedure call raises an error.');

8  -- balance(100); raises an error because the procedure declaration is not unique

9  END;

10  /

The following procedure call raises an error.

PL/SQL procedure successfully completed

SQL>