A Saudi prince has been killed when the helicopter he was travelling in crashed near the border with Yemen, state television reported.