Forum Stats

  • 3,733,845 Users
  • 2,246,829 Discussions
  • 7,856,892 Comments

Discussions

forms post insert trigger

user10991018
user10991018 Member Posts: 142 Blue Ribbon

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.

Answers

Sign In or Register to comment.