ORA-01723: zero-length columns are not allowed

[FS]

Hello ,

i have Oracle 8.1.6 and would create an table from an view (create table xxx as select * from view).
The describe of the view has the following fields:

 ERROR                                     NOT NULL NUMBER(10)
 ERROR_TYPE                                NOT NULL VARCHAR2(3)
 LANGUAGE                                  NOT NULL VARCHAR2(1)
 ERROR_DC                                           VARCHAR2(70)
 IPRODUCT                                           NUMBER
 ERROR_FLAG                                         VARCHAR2(1)
 UP_USER                                   NOT NULL NUMBER(8)
 UP_DATE                                   NOT NULL DATE
 UP_NO                                     NOT NULL NUMBER(3)

The column iproduct is only number. I receive everytime the Ora-01723, is this an bug?

Thanks

Regards

Axel

[Martin Haltmayer]

Hi Axel,

your view looks okay. Try

create table xxx as select * from v_yyy where 0 = 1;

and then

insert into xxx select * from v_yyy; commit;

Martin