Unless the person named in the testament as executor is disqualified on any of the grounds assigned in Article 3097, the court shall render an order upon his petition for confirmation, confirming him as testamentary executor and directing the issuance of letters testamentary to him after he has taken his oath of office and furnished security, if required.