2006-06-27

Oracle burrs

It will work only if to remove small Russian letter p (sounds like r)

declare
buffer varchar2(2000);
parser xmlparser.Parser;
xmlClob CLOB;
begin
parser := xmlparser.newParser;
buffer := '<?xml version="1.0" encoding="ISO-8859-5"?>'
||'<root>абвгдежзиклмнопрстуфхцчшщьыъэюя</root>';
dbms_lob.createtemporary(xmlClob, TRUE);
dbms_lob.open(xmlClob, dbms_lob.lob_readwrite);
dbms_lob.write(xmlClob,length(buffer),1,buffer);
xmlparser.parseClob(parser, xmlClob);
xmlparser.freeParser(parser);
end;

No comments:

Post a Comment