| writeToFile error in xml parser for pl/sql ( oracle xdk),urgent help [message #91581] |
Fri, 29 November 2002 07:43  |
Bharadwaj
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
The problem description in our environment:-
A xmldom package in the oracle 8.1.7 is trying to create an xml file from a DOMdocument. We are creating this DOMdocument by using an xmlparser. The input to the xmlparser is a file on the unix space.We are able to read the values ,display them. The error happens when the writeToFile method is used to update the xml file after changing the node values in the dom document. The environment seems to be okay or is there any problem with it.
To check our logic, a sample code from the web page http://www.akadia.com/services/ora_gen_xml.html was run.It gave the same error description(ORA-20000).It had also used the same function and the error occured at the same line number.The code from the web page reads as:-
"
DECLARE
doc sys.xmldom.DOMDocument;
main_node sys.xmldom.DOMNode;
root_node sys.xmldom.DOMNode;
user_node sys.xmldom.DOMNode;
item_node sys.xmldom.DOMNode;
root_elmt sys.xmldom.DOMElement;
item_elmt sys.xmldom.DOMElement;
item_text sys.xmldom.DOMText;
CURSOR get_users(p_deptno NUMBER) IS
SELECT empno
, ename
, deptno
, rownum
FROM emp
WHERE deptno = p_deptno;
BEGIN
doc := sys.xmldom.newDOMDocument;
main_node := sys.xmldom.makeNode(doc);
root_elmt := sys.xmldom.createElement(
doc
, 'EMPSET'
);
root_node := sys.xmldom.appendChild(
main_node
, sys.xmldom.makeNode(root_elmt)
);
FOR get_users_rec IN get_users(10) LOOP
item_elmt := sys.xmldom.createElement(
doc
, 'EMP'
);
sys.xmldom.setAttribute(
item_elmt
, 'num'
, get_users_rec.rownum
);
user_node := sys.xmldom.appendChild(
root_node
, sys.xmldom.makeNode(item_elmt)
);
item_elmt := sys.xmldom.createElement(
doc
, 'EMP_NO'
);
item_node := sys.xmldom.appendChild(
user_node
, sys.xmldom.makeNode(item_elmt)
);
item_text := sys.xmldom.createTextNode(
doc
, get_users_rec.empno
);
item_node := sys.xmldom.appendChild(
item_node
, sys.xmldom.makeNode(item_text)
);
END LOOP;
sys.xmldom.writeToFile(doc , '/user/tempdocSample.xml');
sys.xmldom.freeDocument(doc);
END;
/"
The table emp was created with values in it.
Oracle error code:-
ORA-20000: An internal error has occurred: Permission denied
ORA-06512: at "SYS.XMLDOM", line 37
ORA-06512: at "SYS.XMLDOM", line 1784
ORA-06512: at line 61
The priveleges that were required for the above code were:-
GRANT javauserpriv to scott;
GRANT javasyspriv to scott;
GRANT EXECUTE ON xmldom TO scott;
These were also existing for our code and database user.NO clue is there about any possible environmental setting errors.
This code was trying to do the same job that we did but created a document object and not used an existing document object(from a parsing operation).Please advice about possible solutions.It is urgent.
Regards
gopal
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
