All Questions
1,572
questions
0
votes
1
answer
33
views
How to replace a substring in a CLOB column in Oracle Table
I have an Oracle Table which has a CLOB column. The CLOB column has the following XML code stored -
<AddressDetails>
<SourceAddressID>41</SourceAddressID>
<...
- 662
0
votes
1
answer
34
views
Oracle XML Parse Error specific to non printable character
My XML Query goes like this.
SELECT X.CODE_VAL, X.CODE_DESC
FROM DATA_TBL A, XML_TBL B,
XMLTABLE('/XPATH/CHILDNODE1/CHILDNODE2' PASSING XMLTYPE(XML_TBL.XMLSTRING_TXT) COLUMNS
CODE_VAL VARCHAR2(100) ...
- 21
0
votes
2
answers
44
views
Prevent Oracle Dbms_XmlDom from escaping attributes
Another question about Oracle's Dbms_XmlDom functionality. This time about setting attributes.
Here's the code:
DECLARE
doc_ dbms_XmlDom.DomDocument := Dbms_XmlDom.newDomDocument;
nd_ ...
- 3,358
1
vote
2
answers
48
views
Creating tags (or nodes) with a Namespace PL/SQL
The following PL/SQL block...
DECLARE
doc_ dbms_XmlDom.DomDocument := Dbms_XmlDom.newDomDocument;
nd_ dbms_XmlDom.DomNode;
nd2_ dbms_XmlDom.DomNode;
tag_ dbms_XmlDom.DomElement;
...
- 3,358
1
vote
0
answers
47
views
DBMS_XMLGEN.CONVERT fails only for clob with special character
I am using Oracle database 19.4 standard edition
This works
select DBMS_XMLGEN.CONVERT((chr(2)) ) from dual;
but when converting to clob it fails
select DBMS_XMLGEN.CONVERT(to_clob(chr(2)) ) from ...
- 181
0
votes
1
answer
62
views
how to Insert XML with more than 4000 bytes characters into a Oracle XMLTYPE column for oracle database 11.2.0.4.0 gr2
i am trying to insert XML with more than 4000 bytes characters into a Oracle XMLTYPE column and i have this error :
ora-06502: pl/sql: numeric or value error: character string buffer too small
i try ...
0
votes
2
answers
35
views
Oracle: XML with multiple nodes with the same name to table
I have a XML file stored in a table with a rather strange structure: it can either not contain a certain node, it can contain it once or it can contain it multiple times. In the below example the node ...
- 82
0
votes
0
answers
60
views
ORA-31043: Element '' not globally defined in schema ''
I am getting an Error
"ORA-31043: Element '' not globally defined in schema ''"
.
I have registered two schemas:
SuministroInformacion.xsd
https://livesql.oracle.com/apex/livesql/s/...
- 1,470
0
votes
2
answers
129
views
XMLTABLE to extract values from CLOB XML with multiple attributes
I have a CLOB XML column in a table with certain fields which I want to extract. The catch here is that some of these fields have multiple attributes, at times different for different rows. For ...
0
votes
1
answer
118
views
XMLTABLE Returning Null for Single & Multiple Lookups
I've done extensive searches on here for similar inquires regarding parsing XML fields which are expected to return 1 or more of the same tags. I've tried to export at least one record before ...
- 646
0
votes
1
answer
210
views
LPX-00217: invalid character 15576961 (U+EDAF81) - How to find the invalid character by Notepad or Notedpad++?
I got error:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 15576961 (U+EDAF81)
I have xml file with customer sensitive data. How to find the ...
- 564
0
votes
2
answers
349
views
Oracle 19c: Extract data (select) from XML (CLOB Type)
I'm trying to extract data from a CLOB data field in xml.
But I'm not succeeding.
A part of XML file:
<tot type="5011">
<eSl xmlns="http://www.dual.com">
&...
- 11
0
votes
1
answer
651
views
BI Publisher - How to get rows to repeat in a table w/ dynamic column on RTF template
I have a table where I am pivoting the data in the last column by accounting date as (ACCOUNTING_DATE) and a debit from one of the subledger tables as (UNROUNDED_ACCOUNTED_DR).
I found an old tutorial ...
- 21
0
votes
1
answer
77
views
Oracle hierarchical query to build xml output
I have a lookup table with parent and child relation.It has a list of tables with parent and child relationship along with the keys to join.I need to create a function to pull the data recursively
...
- 81
0
votes
1
answer
106
views
How get list of namespaces root element in oracle plsql
I want extract list of namespaces from my root element in Oracle PLSQL
My xml is for example: (In real it can be very big)
<my_xml xmlns="http://example.com/ns1" xmlns:foo="http://...
