odd problem when changing a datatype on table

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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: