Question
PL/SQL Oracle 12c. Write a procedure which inputs an account ID and returns the customer information for that account. Purpose: To find the customer information
PL/SQL Oracle 12c. Write a procedure which inputs an account ID and returns the customer information for that account.
Purpose: To find the customer information for a given account number
Input parameters: Account ID
Input/Output parameters: None
Output Parameters: Row of customer table that has the account ID
Preconditions: Account ID is valid
Postconditions: Customer Table unchanged. If customer found, customer row returned. If customer not found, return Message "Cust_ID not valid" and customer row is returned as garbage.
- Write a simple driver to call and test the procedure. The driver should print out the fields of the row that is returned.
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