The Catholic Church here in the US (at least, in San Antonio) will give you a second middle name at the time of your Confirmation. At least they did, back in the 60s.

My wife has a second middle name that you don’t usually see, not even on most official documents. But it is a part of her full legal name.