Oracle Create Table Error

From: <a_aaron_at_hotmail.com>
Date: Wed, 30 Dec 1998 06:44:42 GMT
Message-ID: <76ci4q$4gf$1@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 - 00:44:42 CST