Pooja Dahiya
New Member
In the below code, \[code\]elem\[/code\] is a varchar2 which I need to convert to a node type and replace it with the node to get my stuff. Is anyone able to help me?\[code\]parser := xmlparser.newParser; xmlparser.parseclob(parser,noteTemplates); doc := xmlparser.getdocument(parser); nl := xmldom.getElementsByTagName(doc, 'TEXTFORMAT'); len := xmldom.getlength(nl); -- Loop through elements FOR i IN 0 .. len - 1 LOOP n := xmldom.item(nl, i); childs := xmldom.getChildNodes( n ); for j in 0 .. xmldom.getlength(childs) LOOP node := xmldom.item(childs, j); elem := Find_Text_For_Childs(node); dbms_output.put_line(elem); END LOOP; \[/code\]