When I execute the select statement I keep getting Ora-01843 :
SELECT BIRTHDATE FROM (SELECT XMLTYPE(BFILENAME('DIRECTORY_NAME','FILE_NAME.XML'),NLS_CHARSET_ID(UTF8)) L_CLOB FROM DUAL),xmltable('for $i in /main/DATA_RECORD return $i'passing xml_data columns BIRTHDATE DATE PATH 'BIRTHDATE');
and on the xml file :
<main>
<DATA_RECORD>
<BIRTHDATE>8/29/2021</BIRTHDATE>
</DATA_RECORD>
</main>
Thank you for your help.