Question: THE CODE I MADE IS FOR PART A IT HAS AN ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO BE IN

THE CODE I MADE IS FOR PART A IT HAS AN ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO BE IN ORACLE APPLICATION EXPRESS. The question is the image below

delimiter // CREATE PROCEDURE GET_CREDIT LIMIT( IN I_CUST_ID CHAR(5)) BEGIN DECLARE I_CUSTOMER_NAME VARCHAR(41) DECLARE I CREDIT 1 IMII DECIMAL (7,2); SELECT CONCAT (FIRST NAME, ;, LAST_NAME) AS CUSTOMER_NAME, CREDIT LIMIT INTO I_CUSTOMER NAME, I_CREDIT_LIMIT FROM CUSTOMER WHERE CUST_ID = I CUST ID; SELECT I_CUSTOMER_NAME, I_CREDIT LIMII; END// delimiter; Results Explain Describe Saved SQL. History 0.01 seconds 5. Write MySQL, PL/SQL, or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose ID currently is stored in L_CUST_ID. Place these values in the variables L_CUSTOMER_MAME and L_CREDITUMMT, respectively. Output the contents of L_CUSTOMER_ MAME and L_CREDT_LMIT b. Ohtain the invoice date, customer ID, and first and last names for the invoice whose number currently is stored in LIMWOICE_NUM. Place these values in the variables LIINOICE_DATE, LCUST_ID, and L_CUST_MANE, respectively, Output the contents of LINVOICE_DATE, L_CUSTIID, and LCUST_MANE. c. Add a roiv to the INVOICE table. d. Change the date of the invoice whose number is stored in LINOICE_NUM to the date currently foundin LIINOICE_DATE. Delete the invoice whose number is stored in fluwoick wuM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
