Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PL/SQL Create and invoke a package that contains private and public constructs. a. Create a package specification and package body called EMP_PKG that contains your
PL/SQL
Create and invoke a package that contains private and public constructs. a. Create a package specification and package body called EMP_PKG that contains your ADD_EMPLOYEE and GET_EMPLOYEE procedures as public constructs, and include your VALID_DEPTID function as a private construct. b. Invoke the EMP_PKG.ADD_EMPLOYEE procedure, using department ID 15 for employee Jane Harris with the e-mail ID JAHARRIS. Because department ID 15 does not exist, you should get an error message as specified in the exception handler of your procedure. c. Invoke the ADD_EMPLOYEE package procedure by using department ID 80 for employee David Smith with the e-mail ID DASMITH Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started