Is there anyway to trap the error below in an exception handler? I am using
others and it does not seem to trap this error when I try to delete a parent
record that has child rows. I don't want the delete to work, but I do want
the trigger to ignore this error. NEhelp will be great!

thanks

peace


ERROR at line 1:
ORA-02292: integrity constraint (BHJ.ADDRESS_FK) violated -
child record found


Oracle LazyDBA home page