<?xml version="1.0" encoding="UTF-8"?><alert>
 
	<tab0 comment="section in XSL component" name="Initial Information">
		<details>	
			<Priority>0001</Priority>
			<DateVRUClaimInitiated>2010-06-29</DateVRUClaimInitiated>
		
		</details>
		<contacts comment="grid in XSL component">
			many child nodes here
		</contacts>			
	</tab0>
 
	<tab1 comment="section in XSL component" name="Additional Information">
		<details comment="list collection in XSL component">
			Many child nodes here
		</details>
		<IPAddresses>
			Many child nodes here
		</IPAddresses>		
		<ANIPhones>
			Many child nodes here
		</ANIPhones>
	</tab1>
	
	<tab2 name="Loss Avoidance">
		<losstable>
			Many child nodes here	
		</losstable>
		<summary>
			Many child nodes here	
		</summary>
		<accounts>
			Many child nodes here
		</accounts>
	</tab2>
	
 
	<tab3 name="R &amp; R">		
		<narrative>
			Many child nodes here	
		</narrative>
	</tab3>
 
</alert>

select alert_internal_id,x.* from alerts, xmltable ('.' passing XMLTYPE(xml)
             columns prio varchar2 (5) path '/alert/tab0/details/Priority',
                     dt varchar2 (15) path '/alert/type0/details/DateVRUClaimInitiated',
                     type_comment varchar2 (25) path '/alert/tab0/@comment') x where x.dt is not null; 

select alert_internal_id,extractvalue( xmltype(HTML_FILE_KEY),'/alert/tab0/details/DateVRUClaimInitiated') 
       as check1 
from alerts 
where extractvalue( xmltype(HTML_FILE_KEY),'/alert/tab0/details/DateVRUClaimInitiated') 
        is not null;

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '['
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 1

SQL> with alerts as (
  2   select 1 alert_internal_id,
  3          '<?xml version="1.0" encoding="UTF-8"?><alert>
  4   <tab0 comment="section in XSL component" name="Initial Information">
  5    <details> 
  6     <Priority>0001</Priority>
  7     <DateVRUClaimInitiated>2010-06-29</DateVRUClaimInitiated>
  8    </details>
  9    <contacts comment="grid in XSL component">
 10     many child nodes here
 11    </contacts>   
 12   </tab0>
 13   <tab1 comment="section in XSL component" name="Additional Information">
 14    <details comment="list collection in XSL component">
 15     Many child nodes here
 16    </details>
 17    <IPAddresses>
 18     Many child nodes here
 19    </IPAddresses>  
 20    <ANIPhones>
 21     Many child nodes here
 22    </ANIPhones>
 23   </tab1>
 24   <tab2 name="Loss Avoidance">
 25    <losstable>
 26     Many child nodes here 
 27    </losstable>
 28    <summary>
 29     Many child nodes here 
 30    </summary>
 31    <accounts>
 32     Many child nodes here
 33    </accounts>
 34   </tab2>
 35   <tab3 name="R &amp; R">  
 36    <narrative>
 37     Many child nodes here 
 38    </narrative>
 39   </tab3>
 40  </alert>' HTML_FILE_KEY
 41    from dual
 42    )
 43  select alert_internal_id,extractvalue( xmltype(HTML_FILE_KEY),'/alert/tab0/details/DateVRUClaimInitiated') 
 44         as check1 
 45  from alerts 
 46  where extractvalue( xmltype(HTML_FILE_KEY),'/alert/tab0/details/DateVRUClaimInitiated') 
 47          is not null;
ALERT_INTERNAL_ID CHECK1
----------------- --------------------
                1 2010-06-29

1 row selected.

select alert_internal_id,x.* from alerts, xmltable ('.' passing XMLTYPE(xml)
             columns prio varchar2 (5) path '/alert/tab0/details/Priority',
                     dt varchar2 (15) path '/alert/type0/details/DateVRUClaimInitiated',
                     type_comment varchar2 (25) path '/alert/tab0/@comment') x 
where alert_internal_id < 7000  and x.dt is not null; 
Query returns rows

select alert_internal_id,x.* from alerts, xmltable ('.' passing XMLTYPE(xml)
             columns prio varchar2 (5) path '/alert/tab0/details/Priority',
                     dt varchar2 (15) path '/alert/type0/details/DateVRUClaimInitiated',
                     type_comment varchar2 (25) path '/alert/tab0/@comment') x 
where alert_internal_id < 8000  and x.dt is not null; 
 
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '['
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 1