delete from <table name> cascade ???????/

[ronnie]

Hi,
I am trying to delete a contacts table using the following command but it gives me an error


1* delete from contacts cascade where contact_id=56123
SQL> /
delete from contacts cascade where contact_id=56123
*
ERROR at line 1:
ORA-02292: integrity constraint (COMPANY.SYS_C0029597) violated - child record
found


why doesnt the cascade option work in this case.

Ronnie