Re: how can I save a CLOB in a BLOB

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Feb 2005 17:40:13 -0800
Message-ID: <1107826813.548504.84620@l41g2000cwc.googlegroups.com>

Wally wrote:
> Hi All,
>
> I have two tables between which i have to move data. The first table
> has the data in a CLOB, and the second table has a column that is a
> BLOB. A normal insert into statement i tried failed and i got the
error
> message
>
> ORA-00932: inconsistent datatypes
>
> Is there a way I can convert the CLOB into a BLOB and then insert the
> data ? This is on Oracle 8i.
>
> Thanks in advance.
>
> Wally

As long as you are aware of differences between CLOB (Stores character data single or multibyte) and BLOB (Stores unstructured binary data), you can visit http://tahiti.oracle.com and look for dbms_lob package usage. You work with LOB datatypes via dbms_lob package.

BTW... What's the reason that you want to move data from CLOB to BLOB?

Regards
/Rauf Received on Mon Feb 07 2005 - 19:40:13 CST