Hi All

How to acheive this

I have a lot of tables with lot of primary key - foreign key
In plsql
when any inserts happen in the child table & the corresponding row is not present in the parent table, we get an exception

ORA-02291: integrity constraint (user1.ppk) violated - parent key not found

On this exception , in the exception block i want to trap teh name of the parent table on which the primary key for the particular child table was not there

Is it possible to retrieve the parent table in this way. I am looking for a generic plsql code block which can help to acheive this