HI All,
Java program doing DML's in Oracle DB using JPA calls and these DML's are happening from multiple places. Java inserting data into DB with multiple insert statements like below.
Insert Tab1 Values(1,2);
Insert Tab1 Values(1,3);
…
Insert Tab1 Values(1,10);
COMMIT;
Now we have a requirement to maintain history for each transaction. So is there any way we can write trigger to fire after commit?
Note: It is not possible to make changes in Java side at this point of time.
Oracle Version: 19C