dbms_xmldom.writeToFile() raises ORA-06502 when specifying 'UTF-8' as 3rd parameter
Posted on 2005-03-21
i am trying to create an XML-File from within PL/SQL but there is a big problem when
filesize begins to grow.
Using dbms_xmldom.writeToFile(doc, temp_filename)
(Version with 2 parameters) the file is created without any problems (370kB) but when
a 3rd parameter is specified [dbms_xmldom.writeToFile(doc, temp_filename, 'UTF-8')]
oracle raises exception
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
A creation of an small XML-file (130 Bytes) works fine with the 3rd parameter specified.