title: Can I compile the SP below
body: <p>I need to read a column based on the variable provided then pass the column information to update the row.</p>
  
  <pre><code>create or replace PROCEDURE updatePersonUUID01(
         PFirstName IN PERSON.First_Name%TYPE,
         PLastName  IN PERSON.Last_Name%TYPE,
         PPersonID  out number)
  IS
  BEGIN
  select person_id into ppersonid 
    from Person
    where 
         Person.First_Name = PFirstName 
    AND  Person.Last_Name  = PLastName;
  
    UPDATE person
    SET Login_uuid = NULL 
    WHERE 
        person_id = ppersonid; 
  
  COMMIT;
  END;
  </code></pre>