title: invalid character when extracting xmltype using select in oracle
body: <p>So I wanted to extract using this code from an xml table :</p>
  <pre><code>        SELECT
          DATE, EXTRACT(xmltype(REQ_DETAILS),'/FormManagementVO/SectionsList/Section/BasicFormFields/FormField[FormFieldId=&quot;accountNum&quot;]/FormFieldValue/text()').getStringVal()accountDB 
  WHERE DATE = '2021-05-28'
  </code></pre>
  <p>and there was a condition at the end which is just to filter the date, but somehow in one given date,
  I got an error like :</p>
  <pre><code>ORA-19202 : Error occured in xml processing
  LPX-00217 : invalid character 8 (U+0008)
  Error at line 1
  ORA-06512 : at &quot;SYS.XMLTYPE&quot;, line 272
  </code></pre>
  <p>I have tried to use :</p>
  <pre><code>DBMS_XMLGEN.CONVERT(REGEXP_REPLACE(EXTRACT(xmltype(REQ_DETAILS),'/FormManagementVO/SectionsList/Section/BasicFormFields/FormField[FormFieldId=&quot;ACC_NUMBER&quot;]/FormFieldValue/text()').getStringVal(),'[^[:print:]]',''))
  </code></pre>
  <p>that said can skip the invalid character, but it's wont work. Because I'm pretty new into this, I thought by giving the extract an alias will do, assuming that I was wrong with the syntax like :</p>
  <pre><code>SEL DBMS_XMLGEN.COVERT(REGEXP_REPLACE(A.ACC_NUMBER,'[^[:print:]]',''))
  FROM (
  SEL EXTRACT(xmltype(REQ_DETAILS),'/FormManagementVO/SectionsList/Section/BasicFormFields/FormField[FormFieldId=&quot;ACC_NUMBER&quot;]/FormFieldValue/text()').getStringVal() AS ACC_NUMBER
  FROM xml_mytable
  )
  </code></pre>
  <p>but still throwing the same error, what did I do wrong here?</p>