ORA-02292 Integrity constraint violated
546064Dec 13 2006 — edited Dec 13 2006In a stored procedure, child records are deleted and then parent record is deleted. But it throws the error ORA-02292 Integrity constraint violated, child record found. The error is definitely there but how is this possible or in which case, anything to do with locking??