Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

external table and XMLTAG question

Bruno HensherJan 29 2024

Hi, All!

Why doesn't Oracle loader capable to parse an XML structure, like this:
<employees>

<employee name="John"></employee>

<employee name="Billy"></employee>
</employees>
But with pleasure it works with:
<employees>

<employee >John</employee>

<employee >Billy</employee>
</employees>

I mean an xmltag directive inside oracle's external table creation clause.

It seems that it cannot parse XML document with attributes.
Table is created, yes, but shows no records when I query it…

Any help would br very appreciated.

TIA,
Andrew.

Comments
Post Details
Added on Jan 29 2024
7 comments
261 views