ANKUSH THAVALI
- 11 Nov, 2021
- 0 Comments
- 33 Secs Read
ORA-01723: zero-length columns are not allowed
ORA-01723: zero-length columns are not allowed

Cause: Columns with zero length were not allowed.
Action: Correct the use of the column.
Example to reproduce ORA-01723 -
SQL> Create table mytable as select ename, null age, null doj, null mgrname from scott.emp ; null age * ERROR at line 4: ORA-01723: zero-length columns are not allowed
Solution to avoid ORA-01723 exception use cast:
SQL> Create table mytable as select ename, cast(null as number) age, cast(null as date) doj, cast(null as varchar2(10)) mgrname from scott.emp ; Table created. SQL> desc mytable Name Null? Type ----------------------------------------- -------- ---------------------------- ENAME VARCHAR2(10) AGE NUMBER DOJ DATE MGRNAME VARCHAR2(10)