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!

ORA-04092 (cannot COMMIT or ROLLBACK in a trigger) when updating record

Davor MaricMay 26 2017 — edited May 31 2017

Hi,

I have added a call to a procedure on a different server (through DB Link) in after update trigger, but since, I'm getting error on updating a record in Apex app

I pass some parameters and the procedure updates a table on a remote DB.

is_internal_error: false

ora_sqlcode: -4092

ora_sqlerrm: ORA-04092: cannot in a trigger ORA-02063: preceding line from XE ORA-06512: at "I3CENTAR.XMK_PUNI_RECIDOM_OBJEKT", line 79 ORA-06512: at "I3CENTAR.XMK_PUNI_RECIDOM", line 38 ORA-06512: at "DOM.AUR_STATUSI_SJ", line 40 ORA-04088: error during execution of trigger 'DOM.AUR_STATUSI_SJ'

component.type: APEX_APPLICATION_PAGE_PROCESS

component.id: 43374846668815651

component.name: Process Row of STATUSI_SJ

But, if updating the same table from SQL Developer everything works fine.

How can I get rid of this error from Apex app?

Using Apex 5.1.0.00.45

local DB: 11 XE

remote DB: 11 SE

Regards,

Davor

This post has been answered by Davor Maric on May 30 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2017

Added on May 26 2017

#apex-discussions, #trigger

7 comments

3,024 views