Hello all.
We use version APEX 23.1. and all our DB's are 19.24.
I have multiple applications that has to do updates and/or inserts in another DB over a DB-link that works fine in most applications but one gifs me an ORA-01591.
The application stops working until I give de DB an COMMIT FORCE and our DBA-er has to remove the records in DBA_2PC_PENDING.
In the remote DB there is a package that needs two parameters and gets them from the source-DB (in which APEX is installed).
With those parameters there is first a SELECT-statement to gather more info and than there is an UPDATE for one table and one field in that table; straight foreward.
Such a simple action and I dont know anymore how to go around this error.
Has any of You any idea?
Thanks in advance.