浪潮ps软件保存单据时报错ORA-02290: 违反检查约束条件 (LC0049999.CGFKD_LSBH)

浪潮ps软件:pb开发的客户端软件.

ORA-02290: 违反检查约束条件 (LC0049999.CGFKD_LSBH)

No changes made to database.

INSERT INTO "CGFKD" ( "CGFKD_LSBH", "CGFKD_DJRQ", "CGFKD_YWRQ", "CGFKD_XGSJ", "CGFKD_SJDH", "CGFKD_LBBH", "CGFKD_KPF", "CGFKD_YLZZS", "CGFKD_DDJSF", "CGFKD_HWTGF", "CGFKD_SKF", "CGFKD_BMBH", "CGFKD_ZGBH", "CGFKD_BZ", "CGFKD_LRXM", "CGFKD_WBBH", "CGFKD_HL", "CGFKD_SHLC", "CGFKD_SHBZ", "CGFKD_SHRQ", "CGFKD_SHXM", "CGFKD_JZ", "CGFKD_JZXM", "CGFKD_JSBH", "CGFKD_YBJE", "CGFKD_BBJE", "CGFKD_HXH", "CGFKD_FPHX", "CGFKD_YBZKJE", "CGFKD_BBZKJE", "CGFKD_QCBZ", "CGFKD_PZRQ", "CGFKD_PZNM", "CGFKD_PJHM", "CGFKD_C1", "CGFKD_C2", "CGFKD_C3", "CGFKD_C4", "CGFKD_C5", "CGFKD_U1", "CGFKD_U2", "CGFKD_U3", "CGFKD_YBHXJE", "CGFKD_BBHXJE", "CGFKD_LYBS", "CGFKD_PJLX", "CGFKD_ZBPJLX", "CGFKD_SFQR", "CGFKD_HTLS", "CGFKD_HTBH", "CGFKD_HSDX" )

 VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51 )

用sqlmonitor跟踪了一下 VALUES ( :1........................)中的 :1=' ',注意,是一个空格长度的字符串, 

而浪潮软件的表结构中,cgfkd_lsbh,是此种单据的流水编号,是唯一索引.

之所以报这个错误,是因为cgfkd_lsbh列已经加了check constraints,

-- Create/Recreate check constraints
alter table CGFKD
  add constraint CGFKD_LSBH
  check (CGFKD_lSBH<>' ');

另外还有几个dba视图可以查看constraints信息

USER_CONSTRAINTS和USER_CONS_COLUMNS.

dba_constraints和dba_cons_columns

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/161195/viewspace-588863/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/161195/viewspace-588863/