Re: Troubles with DBMS_XMLGEN

Francesco Sblendorio wrote:

> 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.

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

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)