<div>
<div class="content wysiwyg-content">
We have data from an external system that is XML 1.1. &nbsp;When I use Oracle XML functions to select this data I get error in attached screen print, I am using SQL Developer. &nbsp;Are there other functions I can used for XML 1.1?<br />
<br />
Thanks!<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w10/1084272/Capture.PNG" target="_blank" title="SQL Error (39 KB)"><img alt="SQL Error" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/03_w10/800_1084272/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

We have data from an external system that is XML 1.1.  When I use Oracle XML functions to select this data I get error in attached screen print, I am using SQL Developer.  Are there other functions I can used for XML 1.1?

Thanks!



SQL select XML data in Oracle that is XML 1.1

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.