Xml without encoding on Oracle 11g

Question

I'm working on a stored procedure used to generate a xml file. My problem is that the generated xml file does not contains the encoding tag. Here is a small example:

declare
doc DBMS_XMLDOM.DOMDocument;
l_output_clob CLOB ;

begin

          l_output_clob := ' ';
          doc := DBMS_XMLDOM.newDOMDocument;
          DBMS_XMLDOM.setVersion(doc, '1.0');
          DBMS_XMLDOM.setCharset(doc, 'ISO-8859-15');
          dbms_xmldom.writeToClob(doc,l_output_clob) ;
          dbms_output.put_line(l_output_clob);

end;

When I execute it on a 11g database the result is :

<?xml version="1.0"?>

The code above is used to generate a xml file using :

DBMS_XMLDOM.writeToFile

So the encoding tag is missing and I don't know why. Any idea ?

Thanks alot.

Andris Krauze · Accepted Answer · 2016-03-08 12:27:43Z

1

This might be a workaround, but you can have an encoding attribute as follows:

DECLARE
  doc           dbms_xmldom.domdocument;
  l_output_clob CLOB;
BEGIN

  l_output_clob := ' ';
  doc           := dbms_xmldom.newdomdocument;
  dbms_xmldom.setversion(doc, '1.0" encoding="ISO-8859-15');
  dbms_xmldom.writetoclob(doc, l_output_clob);
  dbms_output.put_line(l_output_clob);
END;

As per Metalink: Xmldom.SetCharSet Not Working With WriteToClob Nor WriteToBuffer (Doc ID 1506543.1)

SETCHARSET procedure is used for writeToFile only. SETCHARSET is ignored in writeToClob and writeToBuffer. This is by design.

answered Mar 8, 2016 at 12:27

Andris Krauze

2,1428 gold badges31 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CC. Over a year ago

Ok, I will use this solution, I knew it but I was looking for something more clean.

Collectives™ on Stack Overflow

Xml without encoding on Oracle 11g

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related