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;