Skip to Content
-1

XMLTABLE function in HANA not working for some XMLs

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>
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 02, 2020 at 03:56 AM

    While I'm no XML expert, I am under the impression that the tag "form" without the quotation marks around the attribute values is malformed XML.

    Valid XML encloses the attribute values in double quotation marks (") - so I would assume that this would be the reason for the failing XMLTABLE parsing.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.