Stored Procedure For RI Violation

Hi All
I have to write a stored procedure , which will check for the RI Violation in the schema and for the parent-child relationship violation ,it will put the error message in the log table.
So my log table looks like:
parent_table
child_table
parent_col
child_col
insert_date
update_date

So once i find the RI constraint violation , I will manually insert the missing parent table value for the existing child table value

So please help me regarding this.

Thanks
With Regards,
Amy

How one can store the value in child record when the parent records does not exist? could you please explain little bit about your data storing method? for example somehow you store data in your child table by disabling Rerferential Integrity constraint and after finishing your work if you try to enable it, I am expecting any errror message to be generated like 'parent record missing' etc.

Hi Shafique

In my schema . I have some existing values in child table for which parent table values are somehow missing.
All I have to do is to check for all those parent-child tables and their correspoding columns and then putting tht information in the exception table
I hope my question is clear now or else please let me know if you need some more information

Thanks

Amy