CREATE OR REPLACE PACKAGE overload IS
FUNCTION double (
var1 NUMBER
) RETURN NUMBER; --pragma restrict_references (double, WNDS,WNPS,RNPS,RNDS);
FUNCTION double (
var1 VARCHAR2
) RETURN VARCHAR2; --pragma restrict_references (double, WNDS,WNPS,RNPS,RNDS);
END;
/
CREATE OR REPLACE PACKAGE BODY overload IS
FUNCTION double (
var1 NUMBER
) RETURN NUMBER IS
BEGIN
RETURN var1 * 2;
END;
FUNCTION double (
var1 VARCHAR2
) RETURN VARCHAR2 IS
BEGIN
RETURN var1
|| '-'
|| var1;
END;
END;
/