Skip to Content
-1
Aug 01, 2020 at 05:59 AM

XMLTABLE function in HANA not working for some XMLs

98 Views

Hi,

I have an XML, which XMLTABLE function is not able to parse, even with using XMLNAMESPACE.

<form xmlns:sr=http://abc.org/abc/xml/screen-runner sr:data-format-version=4.0.0>
            <section-1>
                        <control-1>
                                    Office
                        </control-1>
                        <control-2>
                                    Home
                        </control-2>
            </section-1>
            <section-2>
                        <control-3>
                                    hello
                        </control-3>
                        <control-4>
                                    world
                        </control-4>
            </section-2>
</form>