`

parent key not found

 
阅读更多
--- Cause: java.sql.SQLException: ORA-02291: integrity constraint (SPEC.FK_REFERENCE_570) violated - parent key not found

除了要看,外键是否有值外,还要看外键引用是否正确:外键的用户名,表名,字段
分享到:
评论

相关推荐

    oracle常见错误号

    12. ORA-02291:integrity constraint (约束名) violated - parent key not found - 违反外键约束,父表中缺少相应的主键记录。插入或更新数据时确保满足引用完整性。 13. ORA-02292:integrity constraint ...

    SQL21日自学通

    Integrity Constraint Violated--Parent Key Not Found 482 Oracle Not Available 483 Inserted Value Too Large for Column 483 TNS:listener Could Not Resolve SID Given in Connect Descriptor 484 Insufficient...

    unigui0.83.5.820

    - 0000784: TUniStringGrid: Data not restored after decreasing/increasing Row count - 0000788: Bug in Grid Row/Col translation - 0000787: UniDBGrid: Broken CellSelect behavior - 0000786: MessageDlg ...

    BobBuilder_app

    I decided against using SortedDictionary for the pages as it was slower than a normal Dictionary and for the purpose of a key value store the sorted-ness was not need and could be handled in other ...

    FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir

    list (contains flex-objects with Parent = Nil and the owner = Owner). - FIX: In BCB a problem occurred with TFlexText.DrawText, which for some reason kept being renamed by linker to DrawTextA. For ...

    mysql递归调用获取树节点(子树)

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; OPEN cur; read_loop: LOOP FETCH cur INTO nodeId; IF done THEN LEAVE read_loop; END IF; -- 打印或处理节点,这里只是一个示例,实际应用...

    DevExpress VCL 13.2.5 D7-DXE6 FullSource

    •Q581933 - At design time, modifying any property of a control selected on the parent form selects a control on an inherited form if the parent form contains TdxWizardControl and/or ...

    无限级分类的非递归实现(存储过程版)

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; OPEN cur; read_loop: LOOP FETCH cur INTO child_id; IF done THEN LEAVE read_loop; END IF; -- 打印当前层级的分类 SELECT * FROM ...

    mysql递归查询.txt

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; INSERT INTO tmpLst VALUES (NULL, rootId, nDepth); SET @@max_sp_recursion_depth = 100; OPEN cur1; FETCH cur1 INTO b; WHILE done = 0 DO CALL...

    MySQL 实现树的遍历详解及简单实现示例

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; SET max_sp_recursion_depth=12; INSERT INTO tmpLst VALUES (NULL, rootId, nDepth); OPEN cur1; FETCH cur1 INTO b; WHILE done=0 DO CALL ...

    在Mysql数据库里通过存储过程实现树形的遍历

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; SET max_sp_recursion_depth=12; INSERT INTO tmpLst VALUES (NULL, rootId, nDepth); OPEN cur1; FETCH cur1 INTO b; WHILE done=0 DO CALL pro_cre_...

    Delphi7.1 Update

    Field ‘‘ not found" (Quality Central 5384 and 4823). * TDBRadioGroup maintains its focus on the most recently selected item, even after an edit has been canceled (Quality Central 2109). =======...

    人教版新目标英语初中全单词.doc

    6. **失物招领**:lost(丢失的)、found(找到的)、lost and found(失物招领处)。这些词汇在日常生活中可能会遇到的情况。 7. **家庭成员**:sister(姐姐/妹妹)、mother(妈妈)、father(爸爸)、parent...

    Oracle 开发DBA SQL编写规范

    exit when c_users%notfound; dbms_output.put_line(v_user.name); end loop; close c_users; end; ``` ##### 3.8 尽量使用Oracle原生函数 - 使用Oracle提供的内置函数来简化代码并提高性能。 - 示例: ```...

    TMS Pack for FireMonkey2.3.0.1

    Fixed : Issue with escape key not cancelling edit mode in TTMSFMXGrid v1.6.0.1 Fixed : Issue with double databinding registration in XE2 ios package v1.7.0.0 : New : added components ...

    wget-1.11.4-1

    -i, --input-file=FILE download URLs found in FILE. -F, --force-html treat input file as HTML. -B, --base=URL prepends URL to relative links in -F -i file. Download: -t, --tries=NUMBER ...

    gertt点阵图读取器(opengl)

    * If You've Found This Code Useful, Please Let Me Know. * Visit My Site At nehe.gamedev.net */ #include <stdio.h>> #include <windows.h> // Header File For Windows #include <gl\gl.h> // Header ...

    freemarker总结

    [ {“Akey”:”Avalue”},{“Akey1”:”Avalue1”}, {“Bkey”:”Bvalue”},{“Bkey1”:”Bvalue1”}, ] hashes {“you”:”a”,”me”:”b”,”he”:”c”} 注释标志 这里是注释 --> 旧版本的freemarker采用...

    jQuery完全实例.rar

    This function also accepts XML Documents and Window objects as valid arguments (even though they are not DOM Elements). 返回值 jQuery 参数 elements (Element, Array) : 用于封装成jQuery对象的DOM元素 ...

Global site tag (gtag.js) - Google Analytics