Hi,
In my application i have a requirement to insert the child records once the master record is interted.
eg. I have a form screen related to Dept table.
on when button pressed trigger i am able to insert multiple records in dept table. using sql procedure code using loop.
after each record inserted in dept table the corrosponding emp row need to be inserted.
i wrote a proecedure to insert the row in emp table and called in post insert trigger but nothing inserted.
can you please advise.
my forms and oracle version is 11g.
thanks.