if 1 > (select count(*) from celebrity_professions where 
        prof_id='002' and cel_id=X
) then
   insert into celebrity_professions (cel_id, prof_id) values (X, '002');
end if;