CREATE OR REPLACE PACKAGE product_info_pkg IS PROCEDURE prod_search_pp
(p_id IN bb_product.idproduct%TYPE,
P_sale OUT bb_product.saleprice%TYPE,
P_price OUT bb_product.price%TYPE);
PROCEDURE prod_search_pp
(p_id IN bb_product.productname%TYPE,
P_sale OUT bb_product.saleprice%TYPE,
P_price OUT bb_product.price%TYPE);
END;
The code fragment above is an example of a(n) ____.
A) package body
B) overloaded procedure
C) purity level
D) package scope

Question

Quizplus · Accepted Answer

The code fragment defines an overloaded procedure, where there are two procedures with the same name "prod_search_pp" but with different parameter lists. Therefore, depending on the type of parameter passed during the call, the appropriate procedure will be executed.

CREATE OR REPLACE PACKAGE Product_info_pkg IS PROCEDURE Prod_search_pp