This content has been marked as final. Show 3 replies
The trigger is on the table
the trigger is inserting data into the table
we aare inserting /updating into a table via dblink which internally calls the trigger which is creating problem.
the trigger on the other db is trying to put the data into AQ.
We had succesfull run of the job in between the failure instances also.
we had rolled back the script being executed to a previous version which runs on daily basis it ran successfully.it internally reduced the number of records being proccessed on the single run.
bbut today another batch job which does the similar thing caused the same error.
can u provide some advice to resolve this thing.