ORA-01723: zero-length columns are not allowed 错误解释与解决方案 一、ORA-01723错误信息的含义 ORA-01723 是 Oracle 数据库中的一个常见错误,其含义是“不允许零长度的列”。这个错误通常发生在尝试将空字符串('')或者长度为0的字符串插入到定义为非空(NOT NULL)或者具有特定长度限制的列中时。Oracle 数据...
ORA-01723是ORACLE规定因为列的长度最小应该是1 create or replace view test as select a,b,c,CAST(null AS VARCHAR2(10)) as d,e from apply;试试吧；
The issue is back on Oracle, using the latest commit ce3a5d7. See #598, #317 and #309. ncittm added a commit to ncittm/Achilles that referenced this issue May 17, 2022 Fix Oracle issue zero-length columns are not allowed … ff2d012 ncittm mentioned this issue May 17, 2022 Fix...
环境:create or replace view test as select a,b,c,null as d,e from apply;test视图已存在,上面是定义;现要将test视图数据进行复制,语句如下:create table test1 as select * from test;报错:ORA-01723: zero-length columns are not allowed若语句如下:create table test1 as select a,b,c,e from tes...
ORA-01723: zero-length columns are not allowed 2. Creating aMODEL DIMENSIONon a remote table using a database link results in : SELECT dummy FROM DUAL UNION ALL SELECT y FROM DUAL @<dblink_name> MODEL DIMENSION BY (dummy ) MEASURES (TO_NUMBER (NULL) x,'Y' y) ...
I suspect that you are getting a zero-length string in one of those operations. For error handling purposes it's probably best to call each function on a separate line of code so that you can validate before proceeding to the next operation. Paul ~~~ Microsoft MVP (Visual Basic) Monday...