违反完整性约束 未找到父项关键字

 oracle数据库违反完整性约束的解决办法：

 (1)CREATE OR REPLACE PROCEDURE P_CON_ERR(as_constraint_name varchar2)
    AS
    v_CursorID INTEGER;
    V_CONSNAME VARCHAR2(30);
    V_TABLE_NAME VARCHAR2(30);
    V_RTABLE_NAME VARCHAR2(30);
    V_COLUMN VARCHAR2(100);
    v_Str VARCHAR2(600);
    TYPE t_col_value IS TABLE OF VARCHAR2(30)
    INDEX BY BINARY_INTEGER;
    v_Col_Val t_col_value;
    v_RET NUMBER;
    v_NUM NUMBER;
    i BINARY_INTEGER;
    V_WHERE VARCHAR2(600);
    V_CAUSE VARCHAR2(200);
    CURSOR C_COL_NAME(V_CON_NAME VARCHAR2) IS
    SELECT * FROM USER_CONS_COLUMNS
    WHERE CONSTRAINT_NAME=V_CON_NAME;
    BEGIN
    V_CONSNAME := TRIM(UPPER(as_constraint_name)); -- 约束名称
    v_num :=0;
    FOR T_COL_NAME IN C_COL_NAME(V_CONSNAME) LOOP
    IF (V_NUM = 0) THEN
    V_COLUMN :=T_COL_NAME.COLUMN_NAME;
    V_WHERE :='A.'||T_COL_NAME.COLUMN_NAME||'= B.'||T_COL_NAME.COLUMN_NAME;
    ELSE
    V_COLUMN :=V_COLUMN||','||T_COL_NAME.COLUMN_NAME;