Troubles with DBMS_XMLGEN

From: Francesco Sblendorio <sblendorio_at_despammed.com>
Date: Tue, 10 Feb 2004 14:51:11 +0100
Message-ID: <opr25p3laa526p1e_at_news.cis.dfn.de>

[Quoted] I tried this piece of code on Oracle 9.2.2 and 9.0.1 (SQL*Plus):

---

begin

   dbms_output.put_line(dbms_xmlgen.getxml('select 1 from dual')); end;

---

But... while on the 9.2.2 all is O.K., on the 9.0.1 the following error message is raised:

---

begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number

                    conversion error

ORA-06512: at line 2

---

...while there's no reason for this kind of error.

Can someone help me to understand the reason of this?

Thanks in advance. Received on Tue Feb 10 2004 - 14:51:11 CET