I have XML content in a xml type identifier as shown below.
Expand|Select|Wrap|Line Numbers
- <VitalSummary>
- <VitalMngId/>
- <FacilityTypeId>11</FacilityTypeId>
- <VitalLatesetMngRev>1</VitalLatesetMngRev>
- <VitalFrameId>0</VitalFrameId>
- <MeasureDateTime>20060707163420</MeasureDateTime>
- <CreatePractitioner>20060707163420</CreatePractitioner>
- <CreateDateTime>20060707163420</CreateDateTime>
- <DeleteFlag>0</DeleteFlag>
- <ConnectionNumber>0</ConnectionNumber>
- <PatientId>ANH1</PatientId>
- <ToUpdateFlag>true</ToUpdateFlag>
- <UpdatePractitioner>PRA1</UpdatePractitioner>
- <UpdateDateTime>20060707163420</UpdateDateTime>
- </VitalSummary>
Expand|Select|Wrap|Line Numbers
- PROCEDURE SET_VitalSummary(VitalSummary IN OUT xmltype);
- TnodelistVitFID dbms_xmldom.DOMNodeList;
- TnodeVitFID dbms_xmldom.DOMNode;
- TnodelistVitMngId dbms_xmldom.DOMNodeList;
- TnodeVitMngId dbms_xmldom.DOMNode;
- Tdoc := dbms_xmldom.newDOMDocument(VitalSummary);
- TnodelistVitFID := xslprocessor.selectNodes(dbms_xmldom.makeNode(Tdoc),'/VitalSummary/FacilityTypeId');
- TnodeVitFID := dbms_xmldom.item(TnodelistVitFID , 0);
- dbms_xmldom.setData(dbms_xmldom.getFirstChild(TnodeVitFID), '55');
But I can't change the value of <VitalMngId> using the code as shown below because it is null
Expand|Select|Wrap|Line Numbers
- TnodelistVitMngId := xslprocessor.selectNodes(dbms_xmldom.makeNode(Tdoc),'/VitalSummary/VitalMngId');
- TnodeVitMngId := dbms_xmldom.item(TnodelistVitMngId, 0);
- dbms_xmldom.setData(dbms_xmldom.getFirstChild(TnodeVitFID), '10');
Regards,
Aneesh Kumar.P