I need help with deleting related records

[June7]

Beyond my experience. I have linked to Oracle and SQL dbs but had no permissions to edit data, only read.



I knew the If Then wouldn't make a difference, was an unrelated suggestion.

So this is not actually solved, yet? I will change thread status.

[jjz0512]

Thanks anyway, June7. Your help is always appreciated! I looked further into this error and it's telling me the following;

DELETE FROM "ERMI"."DEMOGRAPHICS" WHERE ROWID = 'AAA5kqAAHAAAAAlAAF' AND ORA_ROWSCN = '5969242213907' and ( "ERMI_ID" is null or "ERMI_ID" is not null )
ORA-02292: integrity constraint (ERMI.NOTES_FK1) violated - child record found

I did a SELECT owner, constraint_name, constraint_type, table_name, r_owner, r_constraint_name
FROM all_constraints
WHERE owner='ERMI'
AND constraint_name='NOTES_FK1'; and wasn't able to find anything. I even took out the constraint_name, and could find a NOTES_FK1 under owner of ERMI.

So I stuck right now.

BTW, where do you change the thread status?

Thanks again, Happy New Year !!!

[June7]

Thread Tools dropdown at top of page.

[jjz0512]

June7, thanks and all members for helping with this issue. I didn't have access before to the NOTES table that had the constraint on. Once added, I was able to remove the constraint and my code worked. This is older code, so many earlier revision still had objects, tables and constraints still set up.

Thanks again everyone!!
Jay