Need questions 1 and 2 answered free of syntax errors if possible.

1. need a procedure named as "GET_CUSTOMER_ADDR" to obtain the whole customer address including Address, City, State & Zip of the customer whose customerID currently is stored in I_CUST_ID. Place the whole customer address in the variable named I_CUST_ADDR. Output the contents of I_CUST_ADDR.

If the input customerID does not exist in the database, display "No such a customer ID: " followed by the customerID. For example, if you try to get the whole customer address of the customer with customerID "125", the result should be "No such a customer ID: 125"."

2. Run your created procedure "GET_CUSTOMER_ADDR" and get the whole address of the two customers: the first customerID is 120, and the second customerID is 230.

3. need a statement that makes sure any customerID entered in ORDERS table also exists in the CUSTOMERS table.