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...


 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_NUMI_FIRST_NAMEI_LAST_NAME
AK102CeydaAksoy





OWNER_NUM<br>LAST_NAME<br>FIRST_NAME<br>ADDRESS<br>CITY<br>STATE<br>ZIP_CODE<br>AK102<br>Aksoy<br>Ceyda<br>411 Griffin Rd.<br>Seattle<br>WA<br>98131<br>BI109<br>Bianchi<br>Nicole<br>7990 Willow Dr.<br>New York<br>NY<br>10005<br>BU106<br>Burke<br>Ernest<br>613 Old Pleasant St.<br>Twin Falls<br>ID<br>83303<br>Co103<br>Cole<br>Мeerab<br>9486 Circle Ave.<br>Olympia<br>WA<br>98506<br>J0110<br>Jones<br>Ammarah<br>730 Military Ave.<br>Seattle<br>WA<br>98126<br>KO104<br>Kowalczyk<br>Jakub<br>7431 S. Bishop St.<br>Bellingham<br>WA<br>98226<br>LO108<br>Lopez<br>Janine<br>9856 Pumpkin Hill Ln.<br>Everett<br>WA<br>98213<br>MO100<br>Мoore<br>Elle-May<br>8006 W. Newport Ave.<br>Reno<br>NV<br>89508<br>PA101<br>Patel<br>Makesh<br>7337 Sheffield St.<br>Seattle<br>WA<br>98119<br>RE107<br>Redman<br>Seth<br>7681 Fordham St.<br>Seattle<br>WA<br>98119<br>S1105<br>Sims<br>Haydon<br>527 Primrose Rd.<br>Portland<br>OR<br>97203<br>

Extracted text: OWNER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP_CODE AK102 Aksoy Ceyda 411 Griffin Rd. Seattle WA 98131 BI109 Bianchi Nicole 7990 Willow Dr. New York NY 10005 BU106 Burke Ernest 613 Old Pleasant St. Twin Falls ID 83303 Co103 Cole Мeerab 9486 Circle Ave. Olympia WA 98506 J0110 Jones Ammarah 730 Military Ave. Seattle WA 98126 KO104 Kowalczyk Jakub 7431 S. Bishop St. Bellingham WA 98226 LO108 Lopez Janine 9856 Pumpkin Hill Ln. Everett WA 98213 MO100 Мoore Elle-May 8006 W. Newport Ave. Reno NV 89508 PA101 Patel Makesh 7337 Sheffield St. Seattle WA 98119 RE107 Redman Seth 7681 Fordham St. Seattle WA 98119 S1105 Sims Haydon 527 Primrose Rd. Portland OR 97203

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here