Yes, the Church codemns sodomy but for that decree to have any "teeth" the Church must act against clergy (including bishops) who are openly gay. Just expect that if you treat homosexual persons with respect, compassion, and sensitivity you may not get that in return.