title: I am able to compile the code but it gives me an error of an sql command. How can I fix this?
body: <p>I was able to write a section of code to delete a customer from the table given the customer email, unfortunately I am running into an error and do not know how to. I am beginner.</p>
  <p>Here is my code:</p>
  <pre><code>CREATE OR REPLACE PROCEDURE DELETE_CUSTOMER(C_EMAIL IN VARCHAR2) 
  IS
    CURSOR CUSTOMERS_CURSOR IS SELECT * FROM CUSTOMER
      WHERE CUSTOMER_OWNER_ID = C_EMAIL);
    V_ROW CUSTOMERS_CURSOR%ROWTYPE;
  
    DELETE_COUNT INTEGER := 0;
  
  BEGIN
    FOR V_ROW IN CUSTOMERS_CURSOR LOOP
      DELETE FROM CUSTOMER WHERE CUSTOMER_EMAIL = V_ROW.CUSTOMER_EMAIL;
      DELETE_CUSTOMER := DELETE_CUSTOMER + 1;
    END LOOP;
    IF DELETE_CUSTOMER = 0 THEN
      DBMS_OUTPUT.PUT_LINE('No customer has this email in our records thus ' ||
      C_EMAIL || ', 0 rows deleted.');
    ELSE
      DBMS_OUTPUT.PUT_LINE(DELETE_CUSTOMER || ' email deleted.');
    END IF;
  END;
  </code></pre>