Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-31020 Invalid pl/sql DOM node list hdl.How can resolve this error?

Status
Not open for further replies.

lorein

Programmer
Oct 21, 2003
25
0
0
MX
Hello

I trying to parse an xml document.
I'm using oracle 9i.
This code for some nodes in the same document works. And for others don't

l_parser2 := dbms_xmlparser.newParser;
dbms_xmlparser.parseClob(l_parser2, l_clob);
l_doc2 := dbms_xmlparser.getDocument(l_parser2);
dbms_xmlparser.freeParser(l_parser2);
l_n2 := dbms_xmldom.makeNode(l_doc2);

l_nl2 := dbms_xslprocessor.selectNodes(l_n2,p_xpath);
FOR adminInfo2 IN 0 .. dbms_xmldom.getLength(l_nl2) - 1 LOOP

l_n2 := dbms_xmldom.item(l_nl2,adminInfo2);

dbms_xslprocessor.valueOf(l_n2,'MfgID/text()',v_mfg_id);

END LOOP

Somebody knows about this issue???
I realy appreciate your help!!
thanks


Lorein....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top