Question: Create a stored procedure named Find_Employee . This procedure gets an employee number and prints the following employee information: First name Last name Email Phone
- Create a stored procedure named Find_Employee. This procedure gets an employee number and prints the following employee information:
First name
Last name
Phone
Hire date
Job title
The procedure gets a value as the p_empid of type NUMBER.
See the following example for employee# of 107:
First name: Summer
Last name: Payn
Email: summer.payne@example.com
Phone: 515.123.8181
Hire date: 07-JUN-16
Job title: Public Accountant
The procedure displays a proper error message if any error occurs.
Show testing with one invalid employee Id and one valid Id.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
