CREATE OR REPLACE PACKAGE ordering_pkg IS
Pv_total_num NUMBER(3,2) ;
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER) ;
FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER;
END;
When creating a package body for the package specification above, which of the following statements is incorrect?
A) The package body must be created using the same name as the existing specification.
B) All code in the procedure and function header sections in the package body must match exactly to the declarations in the corresponding specification.
C) The package body cannot include declarations of variables, cursors, types, and program units not found in the corresponding specification.
D) Items declared in the body and not in the specification can be used only by other procedures and functions within this same package body.
Correct Answer:
Verified
Q26: A(n) program declaration is a declaration of
Q27: Using the same name on multiple program
Q28: Package elements are considered _ if they
Q29: Package elements that can be referenced from
Q30: A(n) _ is a statement used to
Q32: CREATE OR REPLACE PACKAGE ordering_pkg IS
Pv_total_num NUMBER(3,2);
PROCEDURE
Q33: A(n) _ is a declaration of a
Q34: CREATE OR REPLACE PACKAGE ordering_pkg IS
Pv_total_num NUMBER(3,2);
PROCEDURE
Q35: If a cursor is declared in a
Q36: CREATE OR REPLACE PACKAGE metric_pkg IS cup_to_liter
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents