Hi All,
i have the following task. i have a two tables A,B and i have made a common table c which has both the columns of A and B. My new screen will input data into common table C.
once i have the record in common table C then with the help of the trigger i am pushing the data from C based on the record type in to A or B table (same for updates as well). Also when data is inserted or updated in each of table A and B then the record is inserted or updated
into the table C. but i am having the problem of ORA-04088 table is mutating .
can anyone suggest how to handle this situation . i need the option to insert or update both the ways. from A,B -- C or C -- A,B