PL/SQL (MOSC)

MOSC Banner

ORA-04092: cannot ROLLBACK in - can I call an EBS API in trigger

edited Nov 15, 2013 10:40AM in PL/SQL (MOSC) 2 commentsAnswered ✓
Hello,

I would like to call an E Business Suite API in an after insert row trigger.  I get the "ORA-04092: cannot ROLLBACK in" error.  I assume this means the API is doing a commit or rollback, which is not allowed in a trigger.  Before I declare that I cannot do this, I would like confirmation from an expert that what I am attempting will not work.  Is there a work around?

Thank you, Kevin

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center