Hello all,
when i am trying to delete record from below KLMOP"."LOC" i got below error. Not sure what wrong here i am first deleting child record correct?
ORA-02292: integrity constraint FK_CUR_LOC violated - child record found
CREATE TABLE "NMKGL"."USER_LOC"
(
"ID" VARCHAR2(25 CHAR) NOT NULL ENABLE,
"LOC" NUMBER(9,0) NOT NULL ENABLE,
"DELETION" NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE,
"PARENT_ID" NUMBER(9,0),
CONSTRAINT "PK_USER_C_L" PRIMARY KEY ("ID", "LOC")
CONSTRAINT "FK_CUR_LOC" FOREIGN KEY ("L_ID") REFERENCES "KLMOP"."LOC" ("L_ID") ENABLE
)