Getting this error message when trying to access a table via Oracle pipeline functions:
ERROR at line 44:
ORA-20004: ORA-20001: ORA-12840: cannot access a remote table after parallel/insert direct load txn
ORA-06512: at "OPO.OPO_PKG_OUTBOUND_INTERFACE", line 3351
ORA-06512: at line 1
As fas as I can tell, this seems to be caused some sort of uncommitted transaction in a parallel DML operation. What I don't know is how to find out what the transaction is or how to commit it or rollback. This is an urgent production problem, so any help would be appreciated.
Click Here to Expand Forum to Full Width