Hello All,
Below is the logic we implemented in one instance(DEV) where it's working fine but the same is not working as expected in other instance(PROD). The error we got is "NO_DATA_FOUND" exception, in the latter instance.
1) The data we are entering is inserted into a table but not committed.
2) In the same session, we are using a view to query the record that is inserted in step 1.
3) If the record is found in step 2, then it will continue with step 1 with a new record if not, it will do a rollback of the whole transaction.
4) This process continues until all the data is inserted.
Why it's not working in the other instance? What might be wrong.
Thanks!