I had that once and the bank cancelled the payment. I made a mistake in the IBAN but put the right name and address, which did not match the credentials on the IBAN.
It's unfortunate that the bank cannot sent the money back and charge the account that spent it. Many banks do it because just 1 wrong number makes the money go to a completely different person. Banks were supposed to be better than crypto due to reversability of transactions.
This is certainly the advantage of transaction with fiat. Because it has contact with third party, there is possibility of going over details before allowing transaction to be delivered. Sometimes, it is automatically set so that if details don't match, it shows error but cryptocurrency isn't like that. This is the more reason we have to be careful.