Re: any Oracle8 native type to CLOB

On Feb 7, 11:30 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Feb 7, 4:23 pm, "schw" <schwa..._at_alpha.net.pl> wrote:
>
> > HI
>
> > I'm looking for some functions that can convert any oracle type to
> > CLOB, does anybody know how to do it in a generic way ?
>
> > thanks
> > schw
>
> Apart from upgrading to something supported, where there is no need
> for explicit conversion any longer, you mean?
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Not always true...

O:\>sqlplus howards_at_orac

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 8 13:24:49 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options

SQL> create table t0208(c clob);

Table created.

SQL> create table t0208_xml(c xmltype);

Table created.

SQL> insert into t0208_xml values('<myxml>foo</myxml>');

1 row created.

SQL> insert into t0208 select * from t0208_xml; insert into t0208 select * from t0208_xml *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected CLOB got -

SQL> insert into t0208 select x.c.getclobVal() from t0208_xml x;

1 row created.

SQL> Received on Thu Feb 08 2007 - 12:35:47 CST