DBMS_XMLDOM.NEWDOMDOCUMENT function call error : ORA-06502: PL/SQL: numeric or value error: raw variable length too long

Here is my stored proc :

FUNCTION FN_CONVERTTOELEMENTTREE
(sXML  clob,
--sXML  in varchar2, --event Varchar2 parameter is not working
groupName in varchar2,
entryName in varchar2)
RETURN dbms_xmldom.DOMDocument
--permet de retourner un dom document avec des éléments au lieu de attributes
AS
   rdxml dbms_xmldom.DOMDocument;
   xmlDoc dbms_xmldom.DOMDocument;
BEGIN
   rdxml := DBMS_XMLDOM.NEWDOMDOCUMENT(sXML); --here,is the error
  --...

  RETURN (xmlDoc);
END;

Event if I call the function with VB6 or with Jdevelopper or with SQL*Plus : same error.
I'll install 9206 patchset.

Ok, I installed 9.2.0.6 patchset. Same error :

SQL> select FN_CONVERTTOELEMENTTREE2('<a>Hello</a>') from dual;
select FN_CONVERTTOELEMENTTREE2('<a>Hello</a>') from dual
       *
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at "XDB.DBMS_XMLDOM", line 3657
ORA-06512: at "SYSTEM.FN_CONVERTTOELEMENTTREE2", line 6
ORA-06512: at line 1

I think an error could have been inserted during the 9.2.0.5 patchset installation?!?!

Did you test with the stub function above?

If so, You have a problem somewhere else.  I just tested the stub script above from a 10g client using SQL*Plus,  connecting to a 9205 DB and it runs fine for me.

If not, try creating the stub function and try it.

yes, I create the stub and test it and i've got the same error.

I will make a clean reinstall of 9.2.0.5 patchset with a ghost file containing Oracle 9.2.0.2.
 

I just noticed something: Any particular reason you are creating this function as the 'SYSTEM' user?

hmm no, no particular reason...
But I tried it with a different login, and the same error happens.

Ok....  let me know what happens after the re-install.

Slight confusion, you posted the code for the function FN_CONVERTTOELEMENTTREE, however, you are trying to call FN_CONVERTTOELEMENTTREE2, are there any differences between these two functions?  Is line 6 the same?

Sorry,
the FN_CONVERTTOELEMENTTREE2 function is the function that slightwv suggest me to try:

create or replace FUNCTION FN_CONVERTTOELEMENTTREE2 (sXML  clob)
RETURN char
AS
   rdxml dbms_xmldom.DOMDocument;
BEGIN
   rdxml := DBMS_XMLDOM.NEWDOMDOCUMENT(sXML); --here,is the error --line 6
  RETURN 'a';
END;
/

Hi!
No, it still does not work on 9.2.0.6. :(
I want to submit the problem to Oracle, but I can't find out where I could do it.

The next step for me is to try with 9.2.0.2 or 9.2.0.3 versions.

Could you telle me where I should report this bug?
Thank you!

If you have a support contract with Oracle you can log in to metalink to raise bugs (unfortunately the company I work for won't give me access to it!  So I can't direct you any further).

metalink:
http://www.oracle.com/support/metalink/index.html

However, I believe that the problem was caused by the upgrade process.  My local machine was originally 9.2.0.1 and I updgraded to 9.2.0.5, and I get the same error as you.  However, if you drop the xdb user, and recreate it (connected as SYS, run "@catqm.sql change_on_install XDB TEMP"), then try to run the script you do not get that error anymore.  I would look into this issue a bit more than this, the create script throw up a load of errors (that I'm not going to look into), but the xdb user seems to be set up correctly.  There may be something documented in the update patch that we both missed regarding the xdb user!