Re: ORA-01723: zero-length columns are not allowed

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 Received on Sun Oct 15 2000 - 18:29:26 CDT