@Patrick This is somewhat of a tangent from the main topic, but in some cases it is still necessary to explicitly send an EXECUTE(COMMIT) BY AAA. I recently discovered this when I was inserting data into a table while passing the APPEND hint. Without the append hint I could sequentially insert multiple times into the table, but with the APPEND hint, I recieved an error ORA-12840 which states: ORA-12840: cannot access a remote table after parallel/insert direct load txn
Cause: Within a transaction, an attempt was made to perform distributed access after a PDML or insert direct statement had been issued.
Action: Commit/rollback the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction. Adding the explicitly passed commit between each insert resolved the problem and allowed multiple inserts. I don't know why this is since I also assumed everything was being committed automatically in each explicit pass-through block.
... View more
