Hi,
I have a business use case when I have to call package which execute multiple procedures. And, if all goes well then we perform a commit. So, this is one single transaction.
Now, since the amount of data we load is high so we are using PARALLEL hint along with ENABLE_PARALLEL_DML hint in our insert statements to influence optimizer.
However, right after Inserting data we need to read from that same table. But, the restriction says - cannot read/modify an object after modifying it in parallel.
Problem- here is we cannot have commit before selecting the data, neither we are interested in removing the ENABLE_PARALLEL_DML hint.
Question- here is - Is there a way we can use ENABLE_PARALLEL_DML within single transaction.