BEGIN
UPDATE PETS
SET
PET_NAME = :P2_PET_NAME,
PET_BREED = :P2_PET_BREED,
PET_COLOR = :P2_PET_COLOR,
PET_WEIGHT = :P2_PET_WEIGHT,
PET_DOB = :P2_PET_DOB,
PET_GENDER = :P2_PET_GENDER,
PET_SPAY_NEUTER = :P2_PET_SPAY_NEUTER,
PET_STATUS = :P2_PET_STATUS
WHERE PET_NO = :P2_PET_NO;
COMMIT;
END;