Skip to Main Content
Forums

APEX

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!

How to write the trigger on updating or deleting multiple columns on tabular form?

Venky_prsJul 22 2015 — edited Jul 22 2015

Hi,

I'm creating a tabular form from sample_emp table. In that, Whenever, I want to change designation,team_id,team_leader_id,supervisor_id,manager_id it should store the old values of those and update-able values into job_history table. So when, I write trigger for that it shows ' ORA -04082 new or old value not table level triggers ' . Below is my emp_table. My job_history table also similar like this. Need your help.

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9
EMP_IDEMP_NAMEDESIGNATIONTEAM_IDTEAM_LEADER_IDSUPERVISOR_IDMANAGER_IDHIRE_DATERELIEVED_DATE

--

Thanks.
This post has been answered by Jitendra on Jul 22 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2015
Added on Jul 22 2015
#apex-discussions, #plsql
6 comments
444 views