select extractvalue(xmltype(message_text), 'message/detail/recordID'), ,)extractvalue(xmltype(messagetext,'/message/detail/header/message), SYS_NBR, message_type FROM prod.tb_ibrs Where message_type = 'ERR' order by cre_on desc;