Urgent:SIMPLE Need help in getting the node rather than the value of node

Posted on 2007-08-01
Last Modified: 2013-12-18
here is what i am doing

xlist := xslprocessor.selectNodes(xmldom.makeNode(xdoc),'//DataSht/Parameters/*/Pass[text()=''false'']/..');
      htp.p( xmldom.getLength(xlist));
      FOR cur_emp IN 0 .. xmldom.getLength(xlist) - 1 LOOP
          xnode := xmldom.item(xlist, cur_emp);
          p_spec := xslprocessor.VALUEOF(xnode,'Pass');
      end loop;
i can get the value of all those pass nodes whose text is false. now i want to get this failed PASS node's parent value. how can i get it
Question by:samir25
    LVL 60

    Accepted Solution

    can you try something like this?
    xlist := xslprocessor.selectNodes(xmldom.makeNode(xdoc),'//DataSht/Parameters/*[Pass[text()=''false'']]');
    LVL 1

    Author Comment

    the problem is valueof

    p_spec := xslprocessor.VALUEOF(xnode,'Pass');
    I need to print the node not the value.

    with you above change it gave error
    ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00601: Invalid token in: '//DataSht/Parameters/*[Pass[text()='false']]'
    ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 900 ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 928 ORA-06512: at "WEBSTART.TEST1", line 194

    if i remove /.. also (without adding a ]) then also i dont get the desired result. problem is i dont have to use shoudl be something else.
    using like getparentnode. but i am not able to use it
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Please provide a small test case.  This should include sample data and expected results.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now