Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2017 For Windows Web And Database Applications

Authors: Corinne Hoisington

1st Edition

1337102113, 978-1337102117

More Books

Students also viewed these Databases questions