Hi, We are using version 11.2.0.4 Of oracle. We are seeing error "ORA-02067: transaction or savepoint rollback required", while calling one procedure through Db link which is in remote database. its inserting records into a table and then we are trying to fetch those to the local database.
I got to see in below doc, stating the transaction needs to be either rolled back/committed in the remote side only, if it has errored out during the remote call. So i suspect one of the DML trigger which is there in the table to which we are inserting data in the remote database. I am yet to get this error reproduced in the lower environment. The remote procedure is called from Java and i am struggling to understand/debug what exact error its encountering in the remote side , due to which we are seeing this Ora-02067 in local side in Java log.
ORA-02067: Transaction Or Savepoint Rollback Required (Doc ID 472031.1)
Also, wanted to understand, if with respect to fix for this problem, is making the trigger "autonomous transaction" and putting a ROLLBACK in the exception block is the correct approach? or any other approach should be followed?