Are undercover cops psycopaths?

I’d say Connaly is a criminal. Does that mean he betrayed his oath as an FBI agent or did he stay true to his oath as a mobster?