Which method is performance oriented in parsing the XML and perform DML Operations using PL/SQL in Oracle?

I came across different methods while parsing the XML in PL/SQL procedures like

First Way:

CURSOR datahold_xml(student_xmldoc IN xmltype) IS
    SELECT extractvalue(value(t), '/Student/@Enrolled') Enrolled,
           extractvalue(value(t), '/Student/SID') StudentID,
      FROM TABLE(xmlsequence(extract(student_xmldoc , '/Student'))) t;

FOR tempresult_xml IN datahold_xml(student_xmldoc => l_xml) LOOP
    IF UPPER(tempresult_xml.Enrolled) = UPPER('TRUE') THEN
      /* Update Employee Information*/
      UPDATE STUDENTTABLE st
         SET st.firstname = tempresult_xml.FirstName,
             st.lastname  = tempresult_xml.LastName
       WHERE st.SID= tempresult_xml.StudentID;
    ELSE
      /* Do Insert Operation*/
      INSERT INTO STUDENTTABLE (SID,FIRSTNAME,LASTNAME,STATUS)
      VALUES
        (STUDENT_SEQ.NEXTVAL,tempresult_xml.FirstName, tempresult_xml.LastName,'A');
    END IF;
  END LOOP;

The other one is using XSL Processor like

indoc    := '<Student Enrolled="TRUE">
                    <SID>1</SID>
            </Student>
            <Student Enrolled="FALSE">
             <SID>1</SID>
              <FirstName>James</FirstName>
                    <LName>Cameron</LName>
             </Student>';

indomdoc := dbms_xmldom.newDomDocument(indoc);

  l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(indomdoc),
                                        '//STUDENT[@Enrolled="TRUE"]');
  /* Loop to Update Student Information */
  FOR cur_stu IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
    l_n := dbms_xmldom.item(l_nl, cur_stu);
    stu_tab.extend;
       stu_tab(stu_tab.first).FIRSTNAME := dbms_xslprocessor.valueOf(l_n,
                                                            'FirstName/text()');
    stu_tab(stu_tab.first).LASTNAME := dbms_xslprocessor.valueOf(l_n,
                                                           'LName/text()');
    stu_tab(stu_tab.first).SID := dbms_xslprocessor.valueOf(l_n,
                                                             'ID/text()');
    /* Update Student Information*/
    UPDATE STUDENTTABLE st
       SET st.firstname = stu_tab(1).FIRSTNAME,
           st.lastname  = stu_tab(1).LASTNAME
     WHERE es.SID= stu_tab(1).SID;
  END LOOP;

Which of the above methods yield better performan开发者_JS百科ce, using the cursors or xsl processor and DOM.

Please do let me know if there are any other better solutions available to parse the XML.

I am new to ORACLE and Hence in the process of learning..Wanted to try out few methods and want to know which is the best.

Any help would be appreciated.

Thanks, Sameer.

We use xmltable to process xml-s in plsql. If you care about the performance try to measure it for yourself, there are different methods, one of them is autotrace.