表复制数据到dest条，将获得下列错误信息 INSERT INTO dest SELECT * FROM source; SELECT * * ERROR at line 2: ORA...CODE") 1400 ORA-01400: cannot insert NULL into ("TEST"."DEST"."...CODE") 1400 ORA-01400: cannot insert NULL into ("TEST"."DEST"."..., code, description) VALUES (b.id, b.code, b.description); * ERROR at line 9: ORA...CODE") 1400 ORA-01400: cannot insert NULL into ("TEST"."DEST"."
这个问题很多时候是没有为该表建立触发器导致的，或者是sequence没建立，或者是trigger没建立。
into t_def (id, name) values (1, 'a'); insert into t_def (id, name) values (1, 'a') * ERROR at line 1: ORA...SQL> INSERT INTO T_TEST (ID) VALUES (1); INSERT INTO T_TEST (ID) VALUES (1) * 第 1 行出现错误: ORA-01400: 无法将
v_sqlerrm); end if; end; when 块不必跟end结束 if块需跟end if结束 sqlcode为错误码 sqlerrm为oracle反馈的错误信息 此程序输出： -1400 ORA
values(1,null,null); insert into person values(1,null,null) * 第 1 行出现错误: ORA
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("CONFUSER"."ATTACHMENTS"."
但是，但是，创建admin用户密码的时候就报错了，ORA-01400: cannot insert NULL into (“DJANGO”.“AUTH_USER”...._param_generator(params)) cx_Oracle.IntegrityError: ORA-01400: cannot insert NULL into ("DJANGO"."..._param_generator(params)) django.db.utils.IntegrityError: ORA-01400: cannot insert NULL into ("DJANGO
ORA-31693、ORA-01400 ORA-31693: Table data object “LC”....“XXXXXXXXXH_201X0808” failed to load/unload and is being skipped due to error: ORA-01400: cannot insert
非空约束问题 ERROR at line 3: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-01400: cannot
select 60,'HR' from dual; insert into tb_dept(deptno,dname) select 60,'HR' from dual * ERROR at line 1: ORA
>使用SQLERRM根据错误号抛出具体的错误信息 END LOOP; END; There are 3 exceptions Record 2 caused error 1: 1400 ORA...: 12899 ORA-12899: value too large for column (actual: , maximum: ) Record 10 caused error 3: 1400 ORA
hotmail.com',2200,10); VALUES(cons_sequence.nextval,'','Jack@hotmail.com',2200,10) * ERROR at line 2: ORA...hotmail.com',2200,10); VALUES(cons_sequence.nextval,NULL,'Jack@hotmail.com',2200,10) * ERROR at line 2: ORA
S_SYNC) violated 23 11-AUG-12 ins_emp_dest emp_dest 2222 ORA
注意： 如果插入 NULL 值，则会报错 ORA-01400 提示无法插入！
create table lucifer (id number not null); insert into lucifer values (NULL); 注意： 如果插入 NULL 值，则会报错 ORA
persistent LogMiner session ORA-01374: log_parallelism greater than 1 not supported in this release ORA
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
实时音视频
即时通信 IM
