ok it has to be in Oracle. i tried to do part A on my own but I keep getting errors below is a screenshot of what I tried. if the rest of the parts are answered even better

thank you

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 I_CUSTIID. Place these values in the variables L_CUSTOMER_NAME and L_CREDIT_MMIT, respectively. Output the contents of L_CUSTOMER_NAME and L_CREDIT_LIMIT b. Obtain the invoice date, customer ID, and first and last names for the invoice whose number currently is stored in L_INVOICE_NUM. Place these values in the variables I_INVOICE_DATE, I_CUST_ID, and 1_CUST_NAME, respectively. Output the contents of _INVOICE_DATE, I_CUST_ID, and LCUST_NAME. c. Add a row to the INvoice table. d. Change the date of the invoice whose number is stored in L_INVOICE_NUM to the date currently found in I_INVOICE_DATE. e. Delete the invoice whose number is stored in I_INVOICE_NUM. CREATE PROCEDURE GET_CREDIT_LIMITHW ( I_CUST_ID IN CHAR(3)) IS BEGIN SELECT CONCAT(FIRST_NAME, ', ,LAST_NAME) AS I_CUSTOMER_NAME, CREDIT_LIMIT AS I_CREDIT_LIMIT FROM CUSTOMER WHERE CUST_ID = I_CUST_ID; END