Using latest llblgen 4.2, adapter...
I see from the documentation says: If you're using Oracle 12c, please set it to 1.
I have a customer running Oracle 12. Should I tell them they need to set this value?
What is the behavior if this isn't set for Oracle 12?
Thanks!
DQE Compatibility mode (Oracle only)
To set the compatibility mode of the Oracle DQE in the .config file of your application, add the following element to the appSettings section of your application's .config file:
<add key="OracleDQECompatibilityLevel" value="number" />
where number is either 0 or 1: •0 for OracleCompatibilityLevel.Oracle9i10g11g
•1 for OracleCompatibilityLevel.Oracle12c
The default is 0 or Oracle 9i, 10g, 11g. If you're using Oracle 12c, please set it to 1. Setting it to 1, Oracle12c, will make the DQE to emit 12c compatible paging queries using OFFSET FETCH ONLY, and will not emit sequence value retrieval queries for identity fields.