Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> is this expected XMLTYPE function behavior?

is this expected XMLTYPE function behavior?

From: Aakash <bordia_at_gmail.com>
Date: 19 May 2006 00:50:49 -0700
Message-ID: <1148025049.460070.319210@y43g2000cwc.googlegroups.com>


select XMLTYPE(X1) from tab;

ERROR:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.XMLTYPE", line 248
ORA-06512: at line 1

X1 is basically a CLOB and has a null value.

I am on 10gr1

Thanks
Aakash Received on Fri May 19 2006 - 02:50:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US