Skip to Main Content

SQL & PL/SQL

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!

Error during execution of Trigger

user5784286Mar 15 2017 — edited Jan 26 2019

Hi All

            i have the following task. i have a two tables A,B and i have a situation where i need to write a trigger to

populate table B when record is inserted in A and vice versa and also i have to populated some more records into A itself

example if i have start date of 01/01/2016 - 01/10/2016 then i have to populate 10 records in to table B and

remaining 9 records into table A from 01/02/2016 - 01/10/2016 also some times if i enter in table B first then i have to populate

table A as same

i am having problem when i try to create records on the same table my trigger is present . if anyone knows the solution

please let me know

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2017
Added on Mar 15 2017
13 comments
2,545 views