Examine the following package specification. SQLCREATE 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 would it generate an error at run tune?

Question

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 would it generate an error at run tune?

Accepted Answer

B. Because function cannot differ only in return type.

Answer

A. Because function cannot be overload

Answer

C. Because all the functions and procedures In the package cannot have the same number of

Answer

D. Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET

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)…

Question

Options

How the community answered

Community Discussion