Question: CREATE OR REPLACE PACKAGE ordering _ pkg IS pv _ total _ num NUMBER ( 3 , 2 ) ; PROCEDURE order _ total _

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?
Question 12 options:
The package body must be created using the same name as the existing specification.
All code in the procedure and function header sections in the package body must match exactly to the declarations in the corresponding specification.
The package body cannot include declarations of variables, cursors, types, and program units not found in the corresponding specification.
Items declared in the body and not in the specification can be used only by other procedures and functions within this same package body.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!