Home » Developer & Programmer » JDeveloper, Java & XML » problem in dbms_XMLDom
problem in dbms_XMLDom [message #92807] Mon, 31 January 2005 21:39 Go to next message
ORA-31011: XML parsing fa
Messages: 2
Registered: January 2005
Junior Member
HI!
i am trying to generate a XML document within a procedure. the XML document (of DBMS_XMLDOM.DOMDocument type) will be return as an output parameter of the procedure. when i tried to create a new empty DOM document i encounter this error.

ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at "XDB.DBMS_XMLDOM", line 3637

my code looks like the following:
var xmltype;
dom1 := DBMS_XMLDOM.newDOMDocument(var);

even if i do just this
dom1 := DBMS_XMLDOM.newDOMDocument();

i get the same error.
this is occuring only in oracle 9.2.0.6.0. It was working fine in 9.2.0.1.0.

Pls. help.

thanks
Re: problem in dbms_XMLDom [message #468736 is a reply to message #92807] Mon, 02 August 2010 00:04 Go to previous messageGo to next message
ckaushalya
Messages: 1
Registered: August 2010
Junior Member
I came across this error on 'Oracle Database 10g Release 10.2.0.4.0'.

SOLUTION
========
Redeploying the standard oracle package DBMS_XMLDOM solved this error. The file I redeployed is <oraclehome>\product\10.2.0\db_1\RDBMS\ADMIN\catqm.sql.

/Jini
Re: problem in dbms_XMLDom [message #468758 is a reply to message #468736] Mon, 02 August 2010 01:58 Go to previous message
Michel Cadot
Messages: 58860
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the information.

Regards
Michel
Previous Topic: Use Ocx in jsf page using javascript
Next Topic: Io exception: SO Exception was generated
Goto Forum:
  


Current Time: Fri Aug 22 05:41:36 CDT 2014

Total time taken to generate the page: 0.08632 seconds