I would guess the "TO_DATE(NULL)" would give you the zero-length error.
I don't know if you want a default date or not. You could do MANY things
from here.
a_aaron_at_hotmail.com wrote in message <76ci4q$4gf$1_at_nnrp1.dejanews.com>...
>hi, we are facing a strange problem. the following query runs on sqlplus
but
>when ran from sqlplus in telnet session gives the error 1723 "zero-length
>columns are not allowed"
>
>create table xyz as
>select account_id,
> bill_seq_num,
> service_id,
> TO_NUMBER(0) AS meter_reading,
> TO_DATE(NULL) AS meter_reading_dt
>from table_name;
>
>
>thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 30 1998 - 01:21:02 CST
