The XMLTOCURSOR() function cannot handle hierarchical XML. Consider using XmlAdapter.

>I am using the Xmltocursor command to copy data from an xml file to the cursor and then create a view from the cursor like
>XMLTOCURSOR(lcXML, "mycursor", 512)
>REATE SQL VIEW Lvbatch as select * from mycursor.
>
>The problem is that the XLM file has child elements within the parent element tag like
>

><claim>
><claim_no> xxxxx</claim_no>
>-<claim_line>
><DOS>3/11/2006</DOS>
><DOE> 4/12/2006</DOE>
></claim_line>
> </claim>
>

>
>Due to this the view doesnot show me the

<DOS>  and <DOE>

segments, rather append all the data of these segments under claim_line (parent segment) field. Do I have to use the Schema? If yes how to proceed for it? Or is there any other method also? Also the large field names are truncated.
>
>Thanks
>Bharat