USING MYSQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. HERE is what i have so far, but getting these errors DELIMITER // CREATE PROCEDURE DISPLAY_OWNER (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10)) BEGIN
USING MYSQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. HERE is what i have so far, but getting these errors DELIMITER // CREATE PROCEDURE DISPLAY_OWNER (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10)) BEGIN
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
USING MYSQL
Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).
Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME.
HERE is what i have so far, but getting these errors
DELIMITER //
CREATE PROCEDURE DISPLAY_OWNER (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10))
BEGIN
SELECT OWNER_NUM,FIRST_NAME,LASTNAME INTO I_OWNER_NUM,I_FIRST_NAME,I_LAST_NAME
FROM OWNER
WHERE OWNER_NUM = I_OWNER_NUM;
END//
DELIMITER;
also i need to display these outputs
CALL DISPLAY_OWNER('AK102')
Expected Results
I_OWNER_NUM | I_FIRST_NAME | I_LAST_NAME |
---|---|---|
AK102 | Ceyda | Aksoy |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY