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.

Francesco Sblendorio wrote:

9.0.1 was effectively a Beta? Don't use it.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)