Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ON-INSERT and ON-UPDATE triggers

Eslam_ElbyalyAug 17 2014 — edited Aug 19 2014

hi all ,

i have a tabular block ,

the user can insert one row or more than one , i want to know , in this case , which trigger fires ? i believe it's "on-insert" ?

but

what if the user updates a record or more after inserting ? which one will fire ? is it the "on-update" , and the "on-insert" does not ?

and

if the on-insert fire , will it add the same row twice ? i mean will it add it again ?

thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2014
Added on Aug 17 2014
12 comments
11,827 views