Learn the cause and how to resolve the ORA-01723 error message in Oracle.
When you stumble upon an ORA-01723 error, the following error message will appear:
ORA-01723: zero-length columns are not allowed
You tried to create a table, however you unique a column as both CHAR(0) or VARCHAR2(0).
The option(s) to resolve this Oracle error are:
Try editing your CREATE TABLE announcement so that the VARCHAR2 and CHAR columns are at least 1 personality in length.
For example, if you tried to create the following table:
CREATE TABLE supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_name varchar2(0) );
You would receive the following error message:
You ought to correct this error by using defining the contact_name column as a VARCHAR2 column that is at least 1 personality in length:
CREATE TABLE supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_name varchar2(75) );