CREATE TABLE E(
Ok. Table A and table E are populated with a load file process. We will leave table A aside for now.
I am using a trigger on table E to populate tables B, C and D. The trigger has a continue handler for duplicate entries. I managed so far to populate tables B and C but I have REAL trouble on doing the same with table D. I can't find a way to get the primary keys into that table. I've tried to get them into a variable by using the handler's duplicate flag but is not working. Any ideas ? Any help would be highly appreciated. Thank you.