Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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