|
|
 next
|
  Subject: XMLDOM not outputting the file
Author: samir sawant
Date: 23 Feb 2005 12:08 AM
|
Hi I am using following simple pl/sql using xmldom
But i am not able to get the output though procedure runs succesfully.
I am using oracle 9.2.0.4
DECLARE
doc xmldom.DOMDocument;
main_node xmldom.DOMNode;
root_node xmldom.DOMNode;
user_node xmldom.DOMNode;
item_node xmldom.DOMNode;
root_elmt xmldom.DOMElement;
item_elmt xmldom.DOMElement;
item_text xmldom.DOMText;
CURSOR get_users IS
SELECT *
FROM employees;
BEGIN
doc := xmldom.newDOMDocument;
main_node := xmldom.makeNode(doc);
root_elmt := xmldom.createElement(
doc
, 'EMPSET'
);
root_node := xmldom.appendChild(
main_node
, xmldom.makeNode(root_elmt)
);
FOR get_users_rec IN get_users LOOP
item_elmt := xmldom.createElement(
doc
, 'EMP'
);
user_node := xmldom.appendChild(
root_node
, xmldom.makeNode(item_elmt)
);
item_elmt := xmldom.createElement(
doc
, 'EMP_NO'
);
item_node := xmldom.appendChild(
user_node
, xmldom.makeNode(item_elmt)
);
item_text := xmldom.createTextNode(
doc
, get_users_rec.empno
);
item_node := xmldom.appendChild(
item_node
, xmldom.makeNode(item_text)
);
END LOOP;
xmldom.writeToFile(
doc
, 'd:\docSample.xml'
);
xmldom.freeDocument(doc);
end;
/
No file gets generated.
Thanks,
Samir
|
|
|
|
top