Top "Xmltype" questions

Java: Returning XMLType Data from StoredProcedure, Usage of ojdbc6.jar xdb6.jar xmlparserv2.jar for Java to PLSQL interaction

I am following the below tutorial to retrieve XMLType data from a stored procedure http://docs.oracle.com/cd/B19306_01/…

java oracle stored-procedures xmltype

How to store XML data into Oracle tables

In our business, we receive and need to process thousands of XML files per day and all these files are …

xml oracle xsd xmltype oracle-xml-db

How to Extract xmltype as xml in Oracle

I am trying to extract xml from the xmltype doc. DECLARE xmlData XMLType; sDocumentId VARCHAR2(100); sFormat VARCHAR2(100); cData CLOB; BEGIN …

oracle plsql xmltype extract-value

How to extract element-path from XMLType Node?

I would like to have a select statement on an XML document and one column should return me the path …

sql xml oracle xpath xmltype

Update xml tag in a CLOB column in Oracle

I have this xml value in a CLOB column in Oracle 11g: <Energy xmlns="http://euroconsumers.org/notifications/2009/01/notification"&…

sql oracle oracle11g xmltype updatexml

Two classes have the same xml type name

When I try to publish my Workspace in RAD, I get this error "Two classes have the same xml type …

wsdl jaxb cxf wsdl2java xmltype

how to get node name in Oracle SQL extract() with xPath (10g)

Here is a XML file: <ROOT> <A> <B>2</B> <C>3&…

sql oracle xpath xmltype nodename

How to extract leaf nodes from Oracle XMLTYPE

I want to extract only the leaf nodes from an XMLTYPE object in Oracle 10g SELECT t.getStringVal() AS text …

oracle xpath extract xmltype

"ORA-31011: XML parsing failed" when inserting an XML document into a table with XMLType column using Hibernate

I want to store XML data in an Oracle XMLType column with registered XML schema file. Both XML files and …

oracle hibernate spring xmltype ora-31011

PL/SQL XMLTYPE ORA-30625

I'm working with a web service that returns the output below. I'm having a hard time building the XMLTYPE variable …

oracle plsql xmltype