odd problem when changing a datatype on table

From: Chris Stephens <ChrisStephens_at_Affina.com>
Date: Tue, 24 Aug 2004 09:21:03 -0500
Message-ID: <E07BCCA62696AB40BE1267A7419A281A2B5326@apollo.affina.net>

Here's what i did:  

create table order_log2 as select cola, colb, to_number(colc) colc,... from order_log;  

truncate table order_log  

alter table order_log modify (colc number);  

insert into order_log select * from order_log2;  

......and i get:  

ERROR at line 1:

ORA-00932: inconsistent datatypes: expected NUMBER got DATE  

what gives?  

it's not even on the column who's datatype i changed.    

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Aug 24 2004 - 09:17:00 CDT