We are migrating our applcation code to use ODP.Net from ADO.Net provider for better support of recent releases of Oracle.
I am using ODP.Net 19c. This works fine when connected to a 11g database. However, when i test with 12c or 19c databases, i get this error in my .Net code - "ORA-01002: fetch out of sequence"
I found that the executions are happening parallelly which might be causing the issues.Any ideas about this?
Why would the same code work fine with a 11g db and not for 12c or 19c databases?
Can we force sequential execution somehow in the .Net code?
.Net Framework 4.5 , ASP.Net application.
Oracle DB server - 12C or 19C 64-bit
Oracle Client - 19C 32-bit
ODP.Net- 19C (Managed Driver)
While testing for 11g database-
Oracle DB server - 11 64-bit
Oracle Client - 11g 32-bit
ODP.Net- 19C (Managed Driver)
Appreciate any help here.
Thanks!