Error while inserting data into the tableSTREETORA-20503: ENQUEUE FAILURE : for LAQUE_STREET@LAQUE_SAM
ORA-06512: at "UKLINK_OWNER.TRG_LAQUE_STREET", line 86
ORA-25316: Late in the current transaction to begin an Enqueue/Dequeue operation
ORA-04088: error during execution of trigger 'UKLINK_OWNER.TRG_LAQUE_STREET'
ORA-02063: preceding 4 lines from SAM
we are updating to some db through db link in which there a advanced queing system which has a trigger on a table which is creating problem..
can any one help in this regaaard.
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.
This sounds like a bit of a minefield and it is quite difficult to say what might be causing this - has this process been around for a while or have you implemented it and started seeing these issues straight away?
Can I see exactly what the trigger is doing?