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 -> how can I save a CLOB in a BLOB

how can I save a CLOB in a BLOB

From: Wally <wallyraju_at_gmail.com>
Date: 7 Feb 2005 12:34:33 -0800
Message-ID: <1107808473.951010.295090@c13g2000cwb.googlegroups.com> 





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
Received on Mon Feb 07 2005 - 14:34:33 CST












Original text of this message













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