Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS
PROCEDURE search_emp (empdet NUMBER);
PROCEDURE search_emp (empdet DATE);
PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2
PROCEDURE search_emp (empdet NUMBER); RETURN DATE
END emp_pkg
The package is compiled successfully
Why mould it generate an error at run tune?
A.
Because function can not be overload
B.
Because function can not differ only in return type.
C.
Because all the functions and procedures In the package cannot have the same number of
parameters with the same parameter name
D.
Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET
NUMBER) can not have identical parameter names and data types
Explanation:
b
B
hi
i say D
B say : function
D say : procedure, isnt it ?
identical condition wjth B , but it’s for function
Probably it’s mistyping, there is no SEARCH_DEPT procedure in code, so the right answer is B:
Procedure could differ by input parameter type, but not only by return type.
Anyway you can check it variously during running time.
B